DBA Data[Home] [Help]

APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on PAY_RUN_TYPES_F

Line 2217: pay_run_types_f prt

2213: ) is
2214: select paa.assignment_action_id child_assignment_action_id,
2215: 'S' run_type -- Separate Payment Run
2216: from pay_assignment_actions paa, -- Assignment Action of Child Run
2217: pay_run_types_f prt
2218: where paa.source_action_id = p_master_assignment_action -- Assignment Action of Master Run
2219: and paa.payroll_action_id = p_payroll_action_id -- Payroll Action of Master Run
2220: and paa.assignment_id = p_assignment_id
2221: and paa.run_type_id = prt.run_type_id

Line 2234: pay_run_types_f prt1

2230: and paa.action_sequence =
2231: (
2232: select max(paa1.action_sequence)
2233: from pay_assignment_actions paa1,
2234: pay_run_types_f prt1
2235: where prt1.run_type_id = paa1.run_type_id
2236: and prt1.run_method in ('N', 'P')
2237: and paa1.payroll_action_id = p_payroll_action_id -- Payroll Action of Master Run
2238: and paa1.assignment_id = p_assignment_id

Line 2253: pay_run_types_f prt

2249: ) is
2250: select paa.assignment_action_id np_assignment_action_id,
2251: prt.run_method
2252: from pay_assignment_actions paa,
2253: pay_run_types_f prt
2254: where paa.source_action_id = p_assignment_action_id
2255: and paa.payroll_action_id = p_payroll_action_id
2256: and paa.assignment_id = p_assignment_id
2257: and paa.run_type_id = prt.run_type_id