DBA Data[Home] [Help]

APPS.PAY_US_W2C_RPT dependencies on PAY_ACTION_INTERLOCKS

Line 461: from pay_action_interlocks pai,

457: FROM per_all_assignments_f paf1
458: WHERE paf1.assignment_id = paf.assignment_id
459: AND paf1.effective_start_date <= ppa.effective_date)
460: and exists (select 1
461: from pay_action_interlocks pai,
462: pay_assignment_actions paa_paper,
463: pay_payroll_Actions ppa_paper
464: where pai.locked_action_id = paa.assignment_action_id
465: and paa_paper.assignment_Action_id = pai.locking_action_id

Line 480: pay_action_interlocks pai

476: paa.assignment_action_id,
477: substr(paa.serial_number, 1,15) prev_action_id
478: from pay_payroll_actions ppa,
479: pay_assignment_actions paa,
480: pay_action_interlocks pai
481: where pai.locking_action_id = cp_w2cpp_action
482: and paa.assignment_action_id = pai.locked_action_id
483: and ppa.payroll_action_id = paa.payroll_action_id;
484: