DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on PAY_RUN_TYPES_F

Line 2153: pay_run_types_f prtf

2149: cursor csr_run_type(p_assignment_id number,p_eff_date date) is
2150: select prtf.run_type_name
2151: from pay_payroll_actions ppa,
2152: pay_assignment_actions paa,
2153: pay_run_types_f prtf
2154: where paa.assignment_action_id in (SELECT /*+ USE_NL(paa, pact, ptp) */
2155: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2156: paa.assignment_action_id),16)) assignment_action_id
2157: FROM pay_assignment_actions paa,