APPS.PAY_US_1099R_MAG_REPORTING dependencies on PAY_ACTION_INTERLOCKS

Line 324: pay_action_interlocks pai,

320: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,
321: per_all_people_f ppf,
322: ff_user_entities ffue,
323: ff_archive_items ffai,
324: pay_action_interlocks pai,
325: per_all_assignments_f paf,
326: pay_assignment_actions paa,
327: pay_payroll_actions ppa
328: where pai.locking_action_id = paa.assignment_action_id

Line 367: pay_action_interlocks pai,

363: from pay_us_arch_mag_state_v pes, -- pay_us_emp_state_tax_rules_f pes,
364: per_all_people_f ppf,
365: ff_user_entities ffue,
366: ff_archive_items ffai,
367: pay_action_interlocks pai,
368: per_all_assignments_f paf,
369: pay_assignment_actions paa,
370: pay_payroll_actions ppa
371: where pai.locking_action_id = paa.assignment_action_id

Line 419: pay_action_interlocks pai,

415: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,
416: per_all_people_f ppf,
417: ff_user_entities ffue,
418: ff_archive_items ffai,
419: pay_action_interlocks pai,
420: per_all_assignments_f paf,
421: pay_assignment_actions paa,
422: pay_payroll_actions ppa,
423: pay_us_states pus

Line 467: pay_action_interlocks pai,

463: from pay_us_arch_mag_state_v pes, -- pay_us_emp_state_tax_rules_f pes,
464: per_all_people_f ppf,
465: ff_user_entities ffue,
466: ff_archive_items ffai,
467: pay_action_interlocks pai,
468: per_all_assignments_f paf,
469: pay_assignment_actions paa,
470: pay_payroll_actions ppa,
471: pay_us_states pus

Line 635: pay_action_interlocks AI,

631: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
632: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
633: FROM per_all_people_f PE,
634: per_all_assignments_f SS,
635: pay_action_interlocks AI,
636: pay_assignment_actions AA,
637: pay_payroll_actions PA
638: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
639: ('TRANSFER_PAYROLL_ACTION_ID') AND