DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_BUDGET_WF dependencies on PER_ASSIGNMENTS_F

Line 1030: FROM per_assignments_f

1026: WHERE user_id = p_workflow_started_by_id;
1027:
1028: SELECT supervisor_id
1029: INTO p_budget_baseliner_id
1030: FROM per_assignments_f
1031: WHERE person_id = l_employee_id
1032: AND assignment_type in ('C','E') /* Bug#2911451 + FP.M for 'C' */
1033: AND primary_flag = 'Y' /* Bug#2911451 */
1034: AND TRUNC(sysdate) BETWEEN EFFECTIVE_START_DATE