Analytics Software

Hi All,
I don't know this is right Platform to ask this question.
I wrote a SQL Query and i want to create Mapplet for this query. I don't understand in Mapplet which Tools i should use to apply SQL WHERE conditions, I need some guidelines. If i know only one SQL WHERE Condition i can do it for rest. can any one tell me steps to follow?
I really need you HELP.
Regards

SQL QUERY
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select
papf.BUSINESS_GROUP_ID,pap.PAYROLL_ID,pap.PAYROLL_NAME,
papf.PERSON_ID,paaf.ASSIGNMENT_ID,paa.ASSIGNMENT_ACTION_ID,
petf.ELEMENT_TYPE_ID,petf.ELEMENT_NAME,petf.PROCESSING_TYPE,pivf.NAME input_name,
prrv.RESULT_VALUE,prr.ELEMENT_ENTRY_ID,prr.ENTRY_TYPE
from pay_payroll_actions ppa,
pay_assignment_actions paa,
per_time_periods ptp,
pay_all_payrolls_f pap,
pay_run_results prr,
pay_run_result_values prrv,
pay_element_types_f petf,
pay_input_values_f pivf,
pay_element_classifications pec,
per_all_assignments_f paaf,
per_all_people_f papf
where ppa.PAYROLL_ACTION_ID = paa.PAYROLL_ACTION_ID
and ppa.TIME_PERIOD_ID = ptp.TIME_PERIOD_ID
and ppa.PAYROLL_ID = pap.PAYROLL_ID
and paa.ASSIGNMENT_ACTION_ID = prr.ASSIGNMENT_ACTION_ID
and ppa.ACTION_TYPE in ('R','Q')
and ppa.ACTION_STATUS = 'C'
and prr.RUN_RESULT_ID = prrv.RUN_RESULT_ID
and prr.ELEMENT_TYPE_ID = petf.ELEMENT_TYPE_ID
and prrv.INPUT_VALUE_ID = pivf.INPUT_VALUE_ID
and petf.CLASSIFICATION_ID = pec.CLASSIFICATION_ID
and paa.ASSIGNMENT_ID = paaf.ASSIGNMENT_ID
and paaf.PERSON_ID = papf.PERSON_ID
and ppa.EFFECTIVE_DATE between pap.EFFECTIVE_START_DATE and pap.EFFECTIVE_END_DATE
and ppa.EFFECTIVE_DATE between petf.EFFECTIVE_START_DATE and petf.EFFECTIVE_END_DATE
and ppa.EFFECTIVE_DATE between pivf.EFFECTIVE_START_DATE and pivf.EFFECTIVE_END_DATE
and ppa.EFFECTIVE_DATE between paaf.EFFECTIVE_START_DATE and paaf.EFFECTIVE_END_DATE
and ppa.EFFECTIVE_DATE between papf.EFFECTIVE_START_DATE and papf.EFFECTIVE_END_DATE