DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_BUDGET_WF dependencies on PER_ASSIGNMENTS_F

Line 1053: FROM per_assignments_f

1049: WHERE user_id = p_workflow_started_by_id;
1050:
1051: CURSOR c_supervisor_id(p_employee_id NUMBER) IS
1052: SELECT supervisor_id
1053: FROM per_assignments_f
1054: WHERE person_id = l_employee_id
1055: AND assignment_type in ('C','E') -- Bug#2911451 + FP.M for 'C'
1056: AND primary_flag = 'Y' -- Bug#2911451
1057: AND TRUNC(sysdate) BETWEEN EFFECTIVE_START_DATE