DBA Data[Home] [Help]

APPS.PAY_US_RULES dependencies on PAY_ACTION_INTERLOCKS

Line 2480: FROM pay_action_interlocks

2476: AND pai.effective_date BETWEEN popmf.effective_start_date AND popmf.effective_end_date;
2477:
2478: CURSOR get_preassact_id ( arch_assact_id in number) IS
2479: SELECT locked_action_id
2480: FROM pay_action_interlocks
2481: WHERE locking_action_id = arch_assact_id;
2482:
2483: CURSOR get_depoadvice_deatils ( arch_assact_id in number) IS
2484: SELECT pai.action_information5,

Line 2510: FROM pay_action_interlocks pai,

2506: 'C', 'Checking Account',
2507: 'Savings Account'
2508: ),
2509: pain.action_information7
2510: FROM pay_action_interlocks pai,
2511: pay_assignment_actions paa,
2512: pay_payroll_actions ppa,
2513: pay_action_interlocks pai1,
2514: pay_action_information pain

Line 2513: pay_action_interlocks pai1,

2509: pain.action_information7
2510: FROM pay_action_interlocks pai,
2511: pay_assignment_actions paa,
2512: pay_payroll_actions ppa,
2513: pay_action_interlocks pai1,
2514: pay_action_information pain
2515: WHERE pai.locking_action_id = cp_assignment_action_id
2516: AND pai.locked_action_id = pai1.locked_action_id
2517: AND pai.locking_action_id <> pai1.locking_action_id