APPS.PAY_IE_P60XML dependencies on PAY_IE_P35

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

123: begin
124: l_string := p_string;
125: l_string := replace_xml_symbols(l_string);
126:
127: l_string := pay_ie_p35_magtape.test_XML(l_string);
128:
129: RETURN l_string;
130: END ;
131: /* 10277535 end */

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

369: ,pay_ie_prsi_details_f prsif
370: ,pay_all_payrolls_f PAPF
371: WHERE
372: NVl('N','N') = 'N'
373: 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
374: -- and cp_start_date <= to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD') /*4641756*/
375: and ppa35.report_type = 'IEP35'
376: and ppa35.business_group_id = p_business_group_id /* p_business_group_id */
377: and paa.payroll_action_id = ppa35.payroll_action_id

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

370: ,pay_all_payrolls_f PAPF
371: WHERE
372: NVl('N','N') = 'N'
373: 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
374: -- and cp_start_date <= to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD') /*4641756*/
375: and ppa35.report_type = 'IEP35'
376: and ppa35.business_group_id = p_business_group_id /* p_business_group_id */
377: and paa.payroll_action_id = ppa35.payroll_action_id
378: and paa.assignment_id = paf.assignment_id

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

413: )
414: and prsif.assignment_id(+)= paa.assignment_id
415: -- For SR - 5108858.993, similar changes were made to PRSI as
416: -- made for PAYE
417: and prsif.effective_start_date(+) <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/
418: and prsif.effective_end_date(+) >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/
419: --
420: and (prsif.effective_end_date = (select max(prsi.effective_end_date)
421: from pay_ie_prsi_details_f prsi

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

414: and prsif.assignment_id(+)= paa.assignment_id
415: -- For SR - 5108858.993, similar changes were made to PRSI as
416: -- made for PAYE
417: and prsif.effective_start_date(+) <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/
418: and prsif.effective_end_date(+) >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/
419: --
420: and (prsif.effective_end_date = (select max(prsi.effective_end_date)
421: from pay_ie_prsi_details_f prsi
422: where prsi.assignment_id = paa.assignment_id

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

419: --
420: and (prsif.effective_end_date = (select max(prsi.effective_end_date)
421: from pay_ie_prsi_details_f prsi
422: where prsi.assignment_id = paa.assignment_id
423: and prsi.effective_start_date <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/
424: and prsi.effective_end_date >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/
425: )
426: or
427: prsif.effective_end_date IS NULL

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

420: and (prsif.effective_end_date = (select max(prsi.effective_end_date)
421: from pay_ie_prsi_details_f prsi
422: where prsi.assignment_id = paa.assignment_id
423: and prsi.effective_start_date <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/
424: and prsi.effective_end_date >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/
425: )
426: or
427: prsif.effective_end_date IS NULL
428: )

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

449: and papf.consolidation_set_id =nvl(p_consolidation_set_id,PAPF.consolidation_set_id)
450: and PAPF.effective_end_date = (select max(PAPF1.effective_end_date)
451: from pay_all_payrolls_f PAPF1
452: where PAPF1.payroll_id = PAPF.payroll_id
453: and PAPF1.effective_start_date <= cp_end_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')
454: and PAPF1.effective_end_date >= cp_start_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')
455: )
456: AND pact_ade.action_information_category = 'ADDRESS DETAILS'
457: AND pact_ade.action_context_type = 'PA'

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

450: and PAPF.effective_end_date = (select max(PAPF1.effective_end_date)
451: from pay_all_payrolls_f PAPF1
452: where PAPF1.payroll_id = PAPF.payroll_id
453: and PAPF1.effective_start_date <= cp_end_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')
454: and PAPF1.effective_end_date >= cp_start_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')
455: )
456: AND pact_ade.action_information_category = 'ADDRESS DETAILS'
457: AND pact_ade.action_context_type = 'PA'
458: AND pai.action_information_category = 'IE P35 DETAIL'