DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_PROJECT_WF dependencies on PER_ASSIGNMENTS_F

Line 55: FROM per_assignments_f

51: WHERE user_id = p_workflow_started_by_id;
52:
53: CURSOR l_approver_csr IS
54: SELECT supervisor_id
55: FROM per_assignments_f
56: WHERE person_id = l_employee_id
57: /*AND Assignment_type ='E' -- Added this condition for bug 2911451*/ --Commented by avaithia Bug # 3448680
58: AND Assignment_type IN ('E','C') --Included 'C' also in Assignment_type Bug # 3448680
59: AND Primary_flag ='Y' -- Added this condition for bug 2911451