APPS.HR_PRE_PAY dependencies on PAY_RUN_TYPES_F

Line 1492: pay_run_types_f prt

1488: from pay_assignment_actions paa_par,
1489: pay_action_interlocks pai,
1490: pay_assignment_actions paa_chd,
1491: pay_payroll_actions ppa_chd,
1492: pay_run_types_f prt
1493: where paa_par.assignment_action_id = p_assignment_action
1494: and paa_par.assignment_action_id = pai.locking_action_id
1495: and pai.locked_action_id = paa_chd.assignment_action_id
1496: and paa_chd.run_type_id is not null

Line 2050: pay_run_types_f prt

2046: from pay_assignment_actions paa_par,
2047: pay_action_interlocks pai,
2048: pay_assignment_actions paa_chd,
2049: pay_payroll_actions ppa_chd,
2050: pay_run_types_f prt
2051: where paa_par.assignment_action_id = p_assignment_action
2052: and paa_par.assignment_action_id = pai.locking_action_id
2053: and pai.locked_action_id = paa_chd.assignment_action_id
2054: and paa_chd.run_type_id is not null

Line 2536: rt_method pay_run_types_f.run_method%type;

2532: or (negative_pay = 'Y' and
2533: payment_details.category IN ('MT', 'CA')) then
2534: --
2535: declare
2536: rt_method pay_run_types_f.run_method%type;
2537: sep_chq_aa_id pay_assignment_actions.assignment_action_id%type;
2538: begin
2539: --
2540: -- Get the run method

Line 2544: from pay_run_types_f prt,

2540: -- Get the run method
2541: select nvl(prt.run_method, 'N'), paa.assignment_action_id
2542: into rt_method,
2543: sep_chq_aa_id
2544: from pay_run_types_f prt,
2545: pay_assignment_actions paa,
2546: pay_run_results prr,
2547: pay_payroll_actions ppa
2548: where prr.run_result_id = p_run_results