APPS.PAY_IE_EOY_INCOMELEVY_REPORT dependencies on PAY_IE_P35

Line 48: l_string := pay_ie_p35_magtape.test_XML(l_string);

44: begin
45: l_string := p_string;
46: l_string := replace_xml_symbols(l_string);
47:
48: l_string := pay_ie_p35_magtape.test_XML(l_string);
49:
50: RETURN l_string;
51: END ;
52:

Line 285: 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

281: ,pay_ie_prsi_details_f prsif
282: ,pay_all_payrolls_f PAPF
283: WHERE
284: NVl('N','N') = 'N'
285: 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
286: -- and cp_start_date <= to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD') /*4641756*/
287: and ppa35.report_type = 'IEP35'
288: and ppa35.business_group_id = p_business_group_id /* p_business_group_id */
289: and paa.payroll_action_id = ppa35.payroll_action_id

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

282: ,pay_all_payrolls_f PAPF
283: WHERE
284: NVl('N','N') = 'N'
285: 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
286: -- and cp_start_date <= to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD') /*4641756*/
287: and ppa35.report_type = 'IEP35'
288: and ppa35.business_group_id = p_business_group_id /* p_business_group_id */
289: and paa.payroll_action_id = ppa35.payroll_action_id
290: and paa.assignment_id = paf.assignment_id

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

325: )
326: and prsif.assignment_id(+)= paa.assignment_id
327: -- For SR - 5108858.993, similar changes were made to PRSI as
328: -- made for PAYE
329: and prsif.effective_start_date(+) <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/
330: and prsif.effective_end_date(+) >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/
331: --
332: and (prsif.effective_end_date = (select max(prsi.effective_end_date)
333: from pay_ie_prsi_details_f prsi

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

326: and prsif.assignment_id(+)= paa.assignment_id
327: -- For SR - 5108858.993, similar changes were made to PRSI as
328: -- made for PAYE
329: and prsif.effective_start_date(+) <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/
330: and prsif.effective_end_date(+) >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/
331: --
332: and (prsif.effective_end_date = (select max(prsi.effective_end_date)
333: from pay_ie_prsi_details_f prsi
334: where prsi.assignment_id = paa.assignment_id

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

331: --
332: and (prsif.effective_end_date = (select max(prsi.effective_end_date)
333: from pay_ie_prsi_details_f prsi
334: where prsi.assignment_id = paa.assignment_id
335: and prsi.effective_start_date <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/
336: and prsi.effective_end_date >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/
337: )
338: or
339: prsif.effective_end_date IS NULL

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

332: and (prsif.effective_end_date = (select max(prsi.effective_end_date)
333: from pay_ie_prsi_details_f prsi
334: where prsi.assignment_id = paa.assignment_id
335: and prsi.effective_start_date <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/
336: and prsi.effective_end_date >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/
337: )
338: or
339: prsif.effective_end_date IS NULL
340: )

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

361: and papf.consolidation_set_id =nvl(p_consolidation_set_id,PAPF.consolidation_set_id)
362: and PAPF.effective_end_date = (select max(PAPF1.effective_end_date)
363: from pay_all_payrolls_f PAPF1
364: where PAPF1.payroll_id = PAPF.payroll_id
365: and PAPF1.effective_start_date <= cp_end_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')
366: and PAPF1.effective_end_date >= cp_start_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')
367: )
368: AND pact_ade.action_information_category = 'ADDRESS DETAILS'
369: AND pact_ade.action_context_type = 'PA'

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

362: and PAPF.effective_end_date = (select max(PAPF1.effective_end_date)
363: from pay_all_payrolls_f PAPF1
364: where PAPF1.payroll_id = PAPF.payroll_id
365: and PAPF1.effective_start_date <= cp_end_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')
366: and PAPF1.effective_end_date >= cp_start_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')
367: )
368: AND pact_ade.action_information_category = 'ADDRESS DETAILS'
369: AND pact_ade.action_context_type = 'PA'
370: AND pai.action_information_category = 'IE P35 DETAIL'