APPS.PAY_CA_BALANCE_PKG dependencies on PAY_RUN_TYPES_F

Line 150: and not exists ( select 1 from pay_run_types_f prt

146: WHERE pai.locking_action_id = p_prepay_aa_id
147: AND paa.assignment_action_id = pai.locked_action_id
148: AND ppa.payroll_action_id = paa.payroll_action_id
149: AND ppa.action_type IN ('R', 'Q')
150: and not exists ( select 1 from pay_run_types_f prt
151: where prt.legislation_code = 'CA'
152: and prt.run_method = 'S'
153: and prt.run_type_id = paa.run_type_id );
154:

Line 168: , pay_run_types_f prt

164:
165: CURSOR csr_check_sep_chk (p_run_aa_id NUMBER) IS
166: SELECT 1
167: FROM pay_assignment_actions paa
168: , pay_run_types_f prt
169: WHERE paa.assignment_action_id = p_run_aa_id
170: and prt.legislation_code = 'CA'
171: and prt.run_method = 'S'
172: and prt.run_type_id = paa.run_type_id;

Line 455: ,pay_run_types_f prt

451: paa.assignment_id
452: INTO l_sep_check,
453: l_assignment_id
454: FROM pay_assignment_actions paa
455: ,pay_run_types_f prt
456: WHERE paa.assignment_action_id = p_assignment_action_id
457: AND prt.run_type_id = paa.run_type_id
458: AND prt.legislation_code = 'CA';
459: