APPS.PAY_CA_RULES dependencies on PAY_ACTION_INTERLOCKS

Line 444: FROM pay_action_interlocks

440: AND pai.effective_date BETWEEN popmf.effective_start_date AND popmf.effective_end_date;
441:
442: CURSOR get_preassact_id ( arch_assact_id in number) IS
443: /* SELECT locked_action_id
444: FROM pay_action_interlocks
445: WHERE locking_action_id = arch_assact_id; */
446: /* Bug 14052902 - Modified the cursor to display appropriate advice number
447: in Emloyee details section when seperate payemnts are made */
448: SELECT fnd_number.canonical_to_number (substr (serial_number,3))

Line 471: , pay_action_interlocks pail

467: , pay_assignment_actions_pkg.get_payment_status (pail.locked_action_id, pai.action_information15) status
468: FROM pay_action_information pai
469: , pay_org_payment_methods_f popmf
470: , pay_payment_types ppt
471: , pay_action_interlocks pail
472: , pay_payroll_actions ppa
473: , pay_assignment_actions paa
474: , pay_assignment_actions paa2
475: WHERE pai.action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'

Line 498: FROM pay_action_interlocks pai,

494: 'C', 'Checking Account',
495: 'Savings Account'
496: ),
497: pain.action_information7
498: FROM pay_action_interlocks pai,
499: pay_assignment_actions paa,
500: pay_payroll_actions ppa,
501: pay_action_interlocks pai1,
502: pay_action_information pain

Line 501: pay_action_interlocks pai1,

497: pain.action_information7
498: FROM pay_action_interlocks pai,
499: pay_assignment_actions paa,
500: pay_payroll_actions ppa,
501: pay_action_interlocks pai1,
502: pay_action_information pain
503: WHERE pai.locking_action_id = cp_assignment_action_id
504: AND pai.locked_action_id = pai1.locked_action_id
505: AND pai.locking_action_id <> pai1.locking_action_id