APPS.PAY_CA_PAYRG_PKG dependencies on PAY_RUN_TYPES_F

Line 206: from pay_run_types_f

202: order by 3,1,2;
203:
204: cursor c_sepchk_run_type is
205: select run_type_id
206: from pay_run_types_f
207: where legislation_code = 'CA'
208: and run_method = 'S'
209: and shortname = 'SEP_PAY';
210:

Line 249: pay_run_types_f prt,

245: cp_sepchk_run_tp_id number) is
246: select max(paa.assignment_action_id)
247: from pay_assignment_actions paa,
248: pay_action_interlocks pai,
249: pay_run_types_f prt,
250: pay_payroll_actions ppa
251: where pai.locking_action_id = cp_prepay_action_id
252: and paa.assignment_action_id = pai.locked_action_id
253: and paa.assignment_id = cp_assignment_id

Line 268: pay_run_types_f prt,

264: cp_sepchk_run_tp_id number) is
265: select max(paa.assignment_action_id)
266: from pay_assignment_actions paa,
267: pay_action_interlocks pai,
268: pay_run_types_f prt,
269: pay_payroll_actions ppa
270: where pai.locking_action_id = cp_prepay_action_id
271: and paa.assignment_action_id = pai.locked_action_id
272: and paa.assignment_id = cp_assignment_id

Line 307: pay_run_types_f prt

303: select paa_run.action_sequence, paa_run.assignment_action_id
304: from pay_action_interlocks pai,
305: pay_assignment_actions paa_run,
306: pay_payroll_actions ppa_run,
307: pay_run_types_f prt
308: where pai.locking_action_id = cp_prepay_asg_act_id
309: and paa_run.assignment_action_id = pai.locked_action_id
310: and paa_run.assignment_id = cp_assignment_id
311: and ppa_run.payroll_action_id = paa_run.payroll_action_id