APPS.PAY_CA_BALANCE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 148: FROM pay_payroll_actions ppa,

144: RETURN NUMBER IS
145: --
146: CURSOR csr_get_aa_ids (p_prepay_aa_id NUMBER) IS
147: SELECT pai.locked_action_id
148: FROM pay_payroll_actions ppa,
149: pay_assignment_actions paa,
150: pay_action_interlocks pai
151: WHERE pai.locking_action_id = p_prepay_aa_id
152: AND paa.assignment_action_id = pai.locked_action_id

Line 162: FROM pay_payroll_actions ppa,

158: and prt.run_type_id = paa.run_type_id );
159:
160: CURSOR csr_get_prepay_id (p_run_id NUMBER) IS
161: SELECT pai.locking_action_id
162: FROM pay_payroll_actions ppa,
163: pay_assignment_actions paa,
164: pay_action_interlocks pai
165: WHERE pai.locked_action_id = p_run_id
166: AND paa.assignment_action_id = pai.locking_action_id

Line 585: pay_payroll_actions ppa

581: SELECT pai.locking_action_id, count(pai2.locked_action_id)
582: FROM pay_action_interlocks pai,
583: pay_action_interlocks pai2,
584: pay_assignment_actions paa,
585: pay_payroll_actions ppa
586: WHERE pai.locked_action_id = p_asgact_id
587: AND pai.locking_action_id = pai2.locking_action_id
588: AND pai.locking_action_id = paa.assignment_action_id
589: AND paa.payroll_action_id = ppa.payroll_action_id