DBA Data[Home] [Help]

APPS.PAY_US_RULES dependencies on PAY_ACTION_INTERLOCKS

Line 2540: FROM pay_action_interlocks

2536: AND pai.effective_date BETWEEN popmf.effective_start_date AND popmf.effective_end_date;
2537:
2538: CURSOR get_preassact_id ( arch_assact_id in number) IS
2539: SELECT locked_action_id
2540: FROM pay_action_interlocks
2541: WHERE locking_action_id = arch_assact_id;
2542:
2543: CURSOR get_depoadvice_deatils ( arch_assact_id in number) IS
2544: SELECT pai.action_information5,

Line 2572: FROM pay_action_interlocks pai,

2568: 'C', 'Checking Account',
2569: 'Savings Account'
2570: ),
2571: pain.action_information7
2572: FROM pay_action_interlocks pai,
2573: pay_assignment_actions paa,
2574: pay_payroll_actions ppa,
2575: pay_action_interlocks pai1,
2576: pay_action_information pain

Line 2575: pay_action_interlocks pai1,

2571: pain.action_information7
2572: FROM pay_action_interlocks pai,
2573: pay_assignment_actions paa,
2574: pay_payroll_actions ppa,
2575: pay_action_interlocks pai1,
2576: pay_action_information pain
2577: WHERE pai.locking_action_id = cp_assignment_action_id
2578: AND pai.locked_action_id = pai1.locked_action_id
2579: AND pai.locking_action_id <> pai1.locking_action_id