APPS.PAY_US_1099R_MAG_REPORTING dependencies on PAY_ACTION_INTERLOCKS

Line 330: pay_action_interlocks pai,

326: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,
327: per_all_people_f ppf,
328: ff_user_entities ffue,
329: ff_archive_items ffai,
330: pay_action_interlocks pai,
331: per_all_assignments_f paf,
332: pay_assignment_actions paa,
333: pay_payroll_actions ppa
334: where pai.locking_action_id = paa.assignment_action_id

Line 373: pay_action_interlocks pai,

369: from pay_us_arch_mag_state_v pes, -- pay_us_emp_state_tax_rules_f pes,
370: per_all_people_f ppf,
371: ff_user_entities ffue,
372: ff_archive_items ffai,
373: pay_action_interlocks pai,
374: per_all_assignments_f paf,
375: pay_assignment_actions paa,
376: pay_payroll_actions ppa
377: where pai.locking_action_id = paa.assignment_action_id

Line 425: pay_action_interlocks pai,

421: from pay_us_arch_mag_county_v pec, -- pay_us_emp_county_tax_rules_f pec,
422: per_all_people_f ppf,
423: ff_user_entities ffue,
424: ff_archive_items ffai,
425: pay_action_interlocks pai,
426: per_all_assignments_f paf,
427: pay_assignment_actions paa,
428: pay_payroll_actions ppa,
429: pay_us_states pus

Line 473: pay_action_interlocks pai,

469: from pay_us_arch_mag_state_v pes, -- pay_us_emp_state_tax_rules_f pes,
470: per_all_people_f ppf,
471: ff_user_entities ffue,
472: ff_archive_items ffai,
473: pay_action_interlocks pai,
474: per_all_assignments_f paf,
475: pay_assignment_actions paa,
476: pay_payroll_actions ppa,
477: pay_us_states pus

Line 646: pay_action_interlocks AI,

642: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
643: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
644: FROM per_all_people_f PE,
645: per_all_assignments_f SS,
646: pay_action_interlocks AI,
647: pay_assignment_actions AA,
648: pay_payroll_actions PA
649: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
650: ('TRANSFER_PAYROLL_ACTION_ID') AND