APPS.PAY_IE_P60XML dependencies on PAY_IE_P35

Line 282: and to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD') between cp_start_date and cp_end_date

278: ,pay_ie_prsi_details_f prsif
279: ,pay_all_payrolls_f PAPF
280: WHERE
281: NVl('N','N') = 'N'
282: and to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD') between cp_start_date and cp_end_date
283: -- and cp_start_date <= to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD') /*4641756*/
284: and ppa35.report_type = 'IEP35'
285: and ppa35.business_group_id = p_business_group_id /* p_business_group_id */
286: and paa.payroll_action_id = ppa35.payroll_action_id

Line 283: -- and cp_start_date <= to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD') /*4641756*/

279: ,pay_all_payrolls_f PAPF
280: WHERE
281: NVl('N','N') = 'N'
282: and to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD') between cp_start_date and cp_end_date
283: -- and cp_start_date <= to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD') /*4641756*/
284: and ppa35.report_type = 'IEP35'
285: and ppa35.business_group_id = p_business_group_id /* p_business_group_id */
286: and paa.payroll_action_id = ppa35.payroll_action_id
287: and paa.assignment_id = paf.assignment_id

Line 320: and prsif.effective_start_date(+) <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/

316: )
317: and prsif.assignment_id(+)= paa.assignment_id
318: -- For SR - 5108858.993, similar changes were made to PRSI as
319: -- made for PAYE
320: and prsif.effective_start_date(+) <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/
321: and prsif.effective_end_date(+) >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/
322: --
323: and (prsif.effective_end_date = (select max(prsi.effective_end_date)
324: from pay_ie_prsi_details_f prsi

Line 321: and prsif.effective_end_date(+) >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/

317: and prsif.assignment_id(+)= paa.assignment_id
318: -- For SR - 5108858.993, similar changes were made to PRSI as
319: -- made for PAYE
320: and prsif.effective_start_date(+) <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/
321: and prsif.effective_end_date(+) >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/
322: --
323: and (prsif.effective_end_date = (select max(prsi.effective_end_date)
324: from pay_ie_prsi_details_f prsi
325: where prsi.assignment_id = paa.assignment_id

Line 326: and prsi.effective_start_date <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/

322: --
323: and (prsif.effective_end_date = (select max(prsi.effective_end_date)
324: from pay_ie_prsi_details_f prsi
325: where prsi.assignment_id = paa.assignment_id
326: and prsi.effective_start_date <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/
327: and prsi.effective_end_date >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/
328: )
329: or
330: prsif.effective_end_date IS NULL

Line 327: and prsi.effective_end_date >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/

323: and (prsif.effective_end_date = (select max(prsi.effective_end_date)
324: from pay_ie_prsi_details_f prsi
325: where prsi.assignment_id = paa.assignment_id
326: and prsi.effective_start_date <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/
327: and prsi.effective_end_date >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/
328: )
329: or
330: prsif.effective_end_date IS NULL
331: )

Line 356: and PAPF1.effective_start_date <= cp_end_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')

352: and papf.consolidation_set_id =nvl(p_consolidation_set_id,PAPF.consolidation_set_id)
353: and PAPF.effective_end_date = (select max(PAPF1.effective_end_date)
354: from pay_all_payrolls_f PAPF1
355: where PAPF1.payroll_id = PAPF.payroll_id
356: and PAPF1.effective_start_date <= cp_end_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')
357: and PAPF1.effective_end_date >= cp_start_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')
358: )
359: AND pact_ade.action_information_category = 'ADDRESS DETAILS'
360: AND pact_ade.action_context_type = 'PA'

Line 357: and PAPF1.effective_end_date >= cp_start_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')

353: and PAPF.effective_end_date = (select max(PAPF1.effective_end_date)
354: from pay_all_payrolls_f PAPF1
355: where PAPF1.payroll_id = PAPF.payroll_id
356: and PAPF1.effective_start_date <= cp_end_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')
357: and PAPF1.effective_end_date >= cp_start_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')
358: )
359: AND pact_ade.action_information_category = 'ADDRESS DETAILS'
360: AND pact_ade.action_context_type = 'PA'
361: AND pai.action_information_category = 'IE P35 DETAIL'