APPS.PAY_CA_BALANCE_PKG dependencies on PAY_RUN_TYPES_F

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

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

Line 173: , pay_run_types_f prt

169:
170: CURSOR csr_check_sep_chk (p_run_aa_id NUMBER) IS
171: SELECT 1
172: FROM pay_assignment_actions paa
173: , pay_run_types_f prt
174: WHERE paa.assignment_action_id = p_run_aa_id
175: and prt.legislation_code = 'CA'
176: and prt.run_method = 'S'
177: and prt.run_type_id = paa.run_type_id;

Line 477: ,pay_run_types_f prt

473: paa.assignment_id
474: INTO l_sep_check,
475: l_assignment_id
476: FROM pay_assignment_actions paa
477: ,pay_run_types_f prt
478: WHERE paa.assignment_action_id = p_assignment_action_id
479: AND prt.run_type_id = paa.run_type_id
480: AND prt.legislation_code = 'CA';
481: