APPS.PAY_MX_ANNUAL_WRI dependencies on PAY_ACTION_INFORMATION

Line 215: pay_action_information pai

211: FROM per_assignments_f paf,
212: pay_payroll_actions ppa_sua,
213: pay_assignment_actions paa_sua,
214: pay_action_interlocks lck,
215: pay_action_information pai
216: WHERE ppa_sua.payroll_action_id = paa_sua.payroll_action_id
217: AND paa_sua.assignment_id = paf.assignment_id
218: AND paa_sua.assignment_action_id = lck.locking_action_id
219: AND lck.locked_action_id = pai.action_context_id

Line 258: pay_action_information pai,

254: FROM per_assignments_f paf,
255: pay_payroll_actions ppa_sua,
256: pay_assignment_actions paa_sua,
257: pay_action_interlocks lck,
258: pay_action_information pai,
259: pay_population_ranges ppr
260: WHERE ppa_sua.payroll_action_id = paa_sua.payroll_action_id
261: AND paa_sua.assignment_id = paf.assignment_id
262: AND paa_sua.assignment_action_id = lck.locking_action_id

Line 424: FROM pay_action_information pai,

420:
421: CURSOR csr_transactions (cp_wri_asg_act number) IS
422: SELECT pai.action_information_id,
423: nvl(pai.action_information10, 'N') -- Do not report flag
424: FROM pay_action_information pai,
425: pay_action_interlocks lck_sua,
426: pay_action_interlocks lck_arch
427: WHERE lck_sua.locking_action_id = cp_wri_asg_act
428: AND lck_sua.locked_action_id = lck_arch.locking_action_id

Line 443: FROM pay_action_information pai,

439: AND paa.assignment_action_id = cp_asg_act_id;
440:
441: CURSOR csr_person_info (cp_person_id number) IS
442: SELECT pai.action_information_id
443: FROM pay_action_information pai,
444: pay_assignment_actions paa,
445: pay_payroll_actions ppa,
446: pay_action_interlocks lck,
447: pay_assignment_actions paa_arch,

Line 478: FROM pay_action_information pai,

474: ORDER BY fnd_date.canonical_to_date(
475: pay_mx_utility.get_legi_param_val('END_DATE',
476: ppa.legislative_parameters)) DESC;
477: /*SELECT pai.action_information_id
478: FROM pay_action_information pai,
479: pay_action_interlocks lck_sua,
480: pay_action_interlocks lck_arch,
481: pay_payroll_actions ppa_arch,
482: pay_assignment_actions paa_arch

Line 598: FROM pay_action_information pai,

594: PROCEDURE GEN_XML_FOOTER AS
595:
596: CURSOR csr_employer IS
597: SELECT pai.action_information_id
598: FROM pay_action_information pai,
599: pay_action_interlocks lck_sua,
600: pay_action_interlocks lck_arch,
601: pay_assignment_actions paa_arch,
602: pay_assignment_actions paa_wri