APPS.PAY_GB_RTI_OUTPUT dependencies on PAY_PAYROLL_ACTIONS

Line 100: 'pay_payroll_actions ppa '||

96: hr_utility.set_location('Entering: '||l_proc,1);
97:
98: sqlstr := 'select distinct person_id '||
99: 'from per_people_f ppf, '||
100: 'pay_payroll_actions ppa '||
101: 'where ppa.payroll_action_id = :pactid '||
102: 'and ppa.business_group_id = ppf.business_group_id '||
103: 'order by ppf.person_id';
104:

Line 212: from pay_payroll_actions pact

208: (instr(pact.legislative_parameters,'REP_GROUP=')
209: -
210: (instr(pact.legislative_parameters,'ARCHIVE_REQUEST_ID=') + 19))
211: )) arch_payroll_action_id
212: from pay_payroll_actions pact
213: where pact.payroll_action_id = c_mag_payroll_actid;
214:
215: cursor get_heder_details(c_arch_pay_action_id number) is
216: select pai.action_information8 PAYROLL_PROD_VER,

Line 224: from pay_payroll_actions ppa,

220: pai.action_information11 EMPLOYER_AO_REF,
221: pai.action_information12 SENDER_ID,
222: pai.action_information13 TEST_INDICATOR,
223: pai.action_information14 HEADER_VALUE
224: from pay_payroll_actions ppa,
225: pay_action_information pai
226: where ppa.payroll_action_id = c_arch_pay_action_id
227: and ppa.payroll_action_id = pai.action_context_id
228: and pai.action_information_category='RTI PAYROLL INFO'

Line 362: from pay_payroll_actions pact

358: (instr(pact.legislative_parameters,'REP_GROUP=')
359: -
360: (instr(pact.legislative_parameters,'ARCHIVE_REQUEST_ID=') + 19))
361: )) arch_payroll_action_id
362: from pay_payroll_actions pact
363: where pact.payroll_action_id = c_mag_payroll_actid;
364:
365: cursor get_heder_details(c_arch_pay_action_id number) is
366: select pai.action_information8 PAYROLL_PROD_VER,

Line 374: from pay_payroll_actions ppa,

370: pai.action_information11 EMPLOYER_AO_REF,
371: pai.action_information12 SENDER_ID,
372: pai.action_information13 TEST_INDICATOR,
373: pai.action_information14 HEADER_VALUE
374: from pay_payroll_actions ppa,
375: pay_action_information pai
376: where ppa.payroll_action_id = c_arch_pay_action_id
377: and ppa.payroll_action_id = pai.action_context_id
378: and pai.action_information_category='RTI PAYROLL INFO'

Line 574: from pay_payroll_actions pact

570: (instr(pact.legislative_parameters,'REP_GROUP=')
571: -
572: (instr(pact.legislative_parameters,'ARCHIVE_REQUEST_ID=') + 19))
573: )) arch_payroll_action_id
574: from pay_payroll_actions pact
575: where pact.payroll_action_id = c_mag_payroll_actid;
576:
577: /*
578: Below cursor gets corresponding archiver assignment_action_id for the current magtape assignment_action_id

Line 956: from pay_payroll_actions pact

952: (instr(pact.legislative_parameters,'REP_GROUP=')
953: -
954: (instr(pact.legislative_parameters,'ARCHIVE_REQUEST_ID=') + 19))
955: )) arch_payroll_action_id
956: from pay_payroll_actions pact
957: where pact.payroll_action_id = c_mag_payroll_actid;
958:
959: /*
960: Below cursor gets corresponding archiver assignment_action_id for the current magtape assignment_action_id

Line 1135: from pay_payroll_actions pact

1131: (instr(pact.legislative_parameters,'REP_GROUP=')
1132: -
1133: (instr(pact.legislative_parameters,'ARCHIVE_REQUEST_ID=') + 19))
1134: )) arch_payroll_action_id
1135: from pay_payroll_actions pact
1136: where pact.payroll_action_id=pactid;
1137:
1138:
1139: