APPS.PAY_GB_RTI_FPS_OUTPUT dependencies on PAY_PAYROLL_ACTIONS

Line 42: 'pay_payroll_actions ppa '||

38: hr_utility.set_location('Entering: '||l_proc,1);
39:
40: sqlstr := 'select distinct person_id '||
41: 'from per_people_f ppf, '||
42: 'pay_payroll_actions ppa '||
43: 'where ppa.payroll_action_id = :pactid '||
44: 'and ppa.business_group_id = ppf.business_group_id '||
45: 'order by ppf.person_id';
46:

Line 135: from pay_payroll_actions pact

131: (instr(pact.legislative_parameters,'REP_GROUP=')
132: -
133: (instr(pact.legislative_parameters,'ARCHIVE_REQUEST_ID=') + 19))
134: )) arch_payroll_action_id
135: from pay_payroll_actions pact
136: where pact.payroll_action_id = c_mag_payroll_actid;
137:
138: -- Cursor to get Employer footer details
139: cursor get_footer_details(c_arch_pay_action_id number) is

Line 149: from pay_payroll_actions ppa,

145: pai.action_information6,
146: pai.action_information7,
147: pai.action_information8,
148: pai.action_information9
149: from pay_payroll_actions ppa,
150: pay_action_information pai
151: where ppa.payroll_action_id = c_arch_pay_action_id
152: and ppa.payroll_action_id = pai.action_context_id
153: and pai.action_information_category='GB_RTI_FPS_EXTRA_DET'

Line 276: from pay_payroll_actions pact

272: (instr(pact.legislative_parameters,'REP_GROUP=')
273: -
274: (instr(pact.legislative_parameters,'ARCHIVE_REQUEST_ID=') + 19))
275: )) arch_payroll_action_id
276: from pay_payroll_actions pact
277: where pact.payroll_action_id = c_mag_payroll_actid;
278:
279: cursor get_header_details(c_arch_pay_action_id number) is
280: select pai.action_information8 PAYROLL_PROD_VER,

Line 289: from pay_payroll_actions ppa,

285: pai.action_information12 SENDER_ID,
286: pai.action_information13 TEST_INDICATOR,
287: pai.action_information14 HEADER_VALUE,
288: pai.action_information15 TAX_YEAR
289: from pay_payroll_actions ppa,
290: pay_action_information pai
291: where ppa.payroll_action_id = c_arch_pay_action_id
292: and ppa.payroll_action_id = pai.action_context_id
293: and pai.action_information_category='RTI PAYROLL INFO'

Line 608: from pay_payroll_actions pact

604: (instr(pact.legislative_parameters,'REP_GROUP=')
605: -
606: (instr(pact.legislative_parameters,'ARCHIVE_REQUEST_ID=') + 19))
607: )) arch_payroll_action_id
608: from pay_payroll_actions pact
609: where pact.payroll_action_id = c_mag_payroll_actid;
610:
611: /*
612: Below cursor gets corresponding archiver assignment_action_id for the current magtape assignment_action_id

Line 1612: from pay_payroll_actions pact

1608: (instr(pact.legislative_parameters,'REP_GROUP=')
1609: -
1610: (instr(pact.legislative_parameters,'ARCHIVE_REQUEST_ID=') + 19))
1611: )) arch_payroll_action_id
1612: from pay_payroll_actions pact
1613: where pact.payroll_action_id=pactid;
1614:
1615:
1616: