DBA Data[Home] [Help]

APPS.PAY_CORE_PAYSLIP_UTILS dependencies on PAY_RUN_TYPES_F

Line 268: pay_run_types_f prt1

264: SELECT MAX(paa1.action_sequence)
265: into l_act_seq
266: FROM pay_assignment_actions paa1,
267: pay_assignment_actions paa2,
268: pay_run_types_f prt1
269: WHERE prt1.run_type_id = paa1.run_type_id
270: AND prt1.run_method IN ('N','P')
271: AND paa1.payroll_action_id = p_payroll_action_id
272: AND paa1.assignment_id = paa2.assignment_id

Line 327: pay_run_types_f prt

323: p_effective_date DATE ) IS
324: SELECT paa.assignment_action_id child_assignment_action_id,
325: 'S' run_type
326: FROM pay_assignment_actions paa,
327: pay_run_types_f prt
328: WHERE paa.source_action_id = p_master_assignment_action
329: AND paa.payroll_action_id = p_payroll_action_id
330: AND paa.assignment_id = p_assignment_id
331: AND paa.run_type_id = prt.run_type_id

Line 353: pay_run_types_f prt

349: p_effective_date DATE) IS
350: SELECT paa.assignment_action_id np_assignment_action_id,
351: prt.run_method
352: FROM pay_assignment_actions paa,
353: pay_run_types_f prt
354: WHERE paa.source_action_id = p_assignment_action_id
355: AND paa.payroll_action_id = p_payroll_action_id
356: AND paa.assignment_id = p_assignment_id
357: AND paa.run_type_id = prt.run_type_id