DBA Data[Home] [Help]

APPS.PY_ZA_TX_01032013 dependencies on PER_ALL_ASSIGNMENTS_F

Line 4296: l_assignment_number per_all_assignments_f.assignment_number%type;

4292:
4293: l_lmsm_proc_cnt NUMBER;
4294: l_ret_lmsm_proc_cnt NUMBER;
4295: l_65Year Date;
4296: l_assignment_number per_all_assignments_f.assignment_number%type;
4297:
4298: -- Fix for Bug# 12351345
4299:
4300: xpt_FxdPrc EXCEPTION;

Line 4376: FROM per_all_assignments_f paaf

4372:
4373: -- Assignment Number
4374: SELECT paaf.assignment_number
4375: INTO l_assignment_number
4376: FROM per_all_assignments_f paaf
4377: ,pay_payroll_actions ppa
4378: WHERE paaf.assignment_id = ZaTx_01032013.ASSIGNMENT_ID
4379: AND ppa.payroll_action_id = ZaTx_01032013.PAYROLL_ACTION_ID
4380: AND ppa.effective_date