DBA Data[Home] [Help]

APPS.PAY_US_W2C_RPT dependencies on PAY_ACTION_INTERLOCKS

Line 507: from pay_action_interlocks pai,

503: FROM per_all_assignments_f paf1
504: WHERE paf1.assignment_id = paf.assignment_id
505: AND paf1.effective_start_date <= ppa.effective_date)
506: and exists (select 1
507: from pay_action_interlocks pai,
508: pay_assignment_actions paa_paper,
509: pay_payroll_Actions ppa_paper
510: where pai.locked_action_id = paa.assignment_action_id
511: and paa_paper.assignment_Action_id = pai.locking_action_id

Line 526: pay_action_interlocks pai

522: paa.assignment_action_id,
523: substr(paa.serial_number, 1,15) prev_action_id
524: from pay_payroll_actions ppa,
525: pay_assignment_actions paa,
526: pay_action_interlocks pai
527: where pai.locking_action_id = cp_w2cpp_action
528: and paa.assignment_action_id = pai.locked_action_id
529: and ppa.payroll_action_id = paa.payroll_action_id;
530: