APPS.HR_PRE_PAY dependencies on PAY_RUN_TYPES_F

Line 1487: pay_run_types_f prt

1483: from pay_assignment_actions paa_par,
1484: pay_action_interlocks pai,
1485: pay_assignment_actions paa_chd,
1486: pay_payroll_actions ppa_chd,
1487: pay_run_types_f prt
1488: where paa_par.assignment_action_id = p_assignment_action
1489: and paa_par.assignment_action_id = pai.locking_action_id
1490: and pai.locked_action_id = paa_chd.assignment_action_id
1491: and paa_chd.run_type_id is not null

Line 2045: pay_run_types_f prt

2041: from pay_assignment_actions paa_par,
2042: pay_action_interlocks pai,
2043: pay_assignment_actions paa_chd,
2044: pay_payroll_actions ppa_chd,
2045: pay_run_types_f prt
2046: where paa_par.assignment_action_id = p_assignment_action
2047: and paa_par.assignment_action_id = pai.locking_action_id
2048: and pai.locked_action_id = paa_chd.assignment_action_id
2049: and paa_chd.run_type_id is not null

Line 2500: rt_method pay_run_types_f.run_method%type;

2496: or (negative_pay = 'Y' and
2497: payment_details.category IN ('MT', 'CA')) then
2498: --
2499: declare
2500: rt_method pay_run_types_f.run_method%type;
2501: sep_chq_aa_id pay_assignment_actions.assignment_action_id%type;
2502: begin
2503: --
2504: -- Get the run method

Line 2508: from pay_run_types_f prt,

2504: -- Get the run method
2505: select nvl(prt.run_method, 'N'), paa.assignment_action_id
2506: into rt_method,
2507: sep_chq_aa_id
2508: from pay_run_types_f prt,
2509: pay_assignment_actions paa,
2510: pay_run_results prr,
2511: pay_payroll_actions ppa
2512: where prr.run_result_id = p_run_results