DBA Data[Home] [Help]

APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on PAY_RUN_TYPES_F

Line 2477: pay_run_types_f prt

2473: ) is
2474: select paa.assignment_action_id child_assignment_action_id,
2475: 'S' run_type -- Separate Payment Run
2476: from pay_assignment_actions paa, -- Assignment Action of Child Run
2477: pay_run_types_f prt
2478: where paa.source_action_id = p_master_assignment_action -- Assignment Action of Master Run
2479: and paa.payroll_action_id = p_payroll_action_id -- Payroll Action of Master Run
2480: and paa.assignment_id = p_assignment_id
2481: and paa.run_type_id = prt.run_type_id

Line 2494: pay_run_types_f prt1

2490: and paa.action_sequence =
2491: (
2492: select max(paa1.action_sequence)
2493: from pay_assignment_actions paa1,
2494: pay_run_types_f prt1
2495: where prt1.run_type_id = paa1.run_type_id
2496: and prt1.run_method in ('N', 'P')
2497: and paa1.payroll_action_id = p_payroll_action_id -- Payroll Action of Master Run
2498: and paa1.assignment_id = p_assignment_id

Line 2513: pay_run_types_f prt

2509: ) is
2510: select paa.assignment_action_id np_assignment_action_id,
2511: prt.run_method
2512: from pay_assignment_actions paa,
2513: pay_run_types_f prt
2514: where paa.source_action_id = p_assignment_action_id
2515: and paa.payroll_action_id = p_payroll_action_id
2516: and paa.assignment_id = p_assignment_id
2517: and paa.run_type_id = prt.run_type_id