APPS.PAY_PAYRG_PKG dependencies on PAY_RUN_TYPES_F

Line 404: from pay_run_types_f prt

400: and ((paa.run_type_id is null and paa.source_action_id is null) or
401: (paa.run_type_id is not null and paa.source_action_id is not null
402: and paa.run_type_id in
403: (select prt.run_type_id
404: from pay_run_types_f prt
405: where prt.shortname <> 'SEPCHECK'
406: and prt.legislation_code = 'US'
407: and ppa.effective_date between prt.effective_start_date
408: and prt.effective_end_date)

Line 426: from pay_run_types_f prt

422: and ((paa.run_type_id is null and paa.source_action_id is null) or
423: (paa.run_type_id is not null and paa.source_action_id is not null
424: and paa.run_type_id in
425: (select prt.run_type_id
426: from pay_run_types_f prt
427: where prt.shortname <> 'SEPCHECK'
428: and prt.legislation_code = 'US'
429: and ppa.effective_date between prt.effective_start_date
430: and prt.effective_end_date)

Line 459: pay_run_Types_f prt,

455: cursor c_multi_asg_acts (cp_pre_pymt_action_id in number) is
456: select max(paa2.assignment_action_id)
457: from pay_assignment_actions paa2, -- assignment_actions for slave payroll runs.
458: pay_assignment_actions paa1, -- assignment_action for master payroll run
459: pay_run_Types_f prt,
460: pay_payroll_actions ppa,
461: pay_action_interlocks pai
462: where pai.locking_action_id = cp_pre_pymt_action_id
463: and pai.locked_action_id = paa1.assignment_action_id

Line 487: pay_run_Types_f prt,

483: from pay_assignment_actions paa2,
484: -- assignment_actions for slave payroll runs.
485: pay_assignment_actions paa1,
486: -- assignment_action for master payroll run
487: pay_run_Types_f prt,
488: pay_payroll_actions ppa,
489: pay_action_interlocks pai
490: where pai.locking_action_id = cp_pre_pymt_action_id
491: and pai.locked_action_id = paa1.assignment_action_id