DBA Data[Home] [Help]

APPS.PJM_MASS_TRANSFER_WF dependencies on WF_ROLES

Line 39: FROM pa_project_players P , wf_roles R

35: RETURN VARCHAR2 IS
36:
37: CURSOR c IS
38: SELECT R.name
39: FROM pa_project_players P , wf_roles R
40: WHERE P.project_role_type = 'PROJECT MANAGER'
41: AND P.project_id = X_Project_ID
42: AND sysdate BETWEEN P.start_date_active AND nvl(P.end_date_active , sysdate + 1)
43: AND R.orig_system_id = P.person_id