APPS.PA_DCTN_APRV_NOTIFICATION dependencies on PA_PROJECTS

Line 14: FROM PA_PROJECTS

10: ,completion_date end_date
11: ,project_type project_type
12: ,carrying_out_organization_id organization_id
13: ,project_status_code project_status
14: FROM PA_PROJECTS
15: WHERE project_id = p_project_id;
16:
17: CURSOR c_dctn_hdr(p_dctn_req_id NUMBER) IS
18: SELECT *

Line 40: AND ppp.object_type = 'PA_PROJECTS'

36: AND ppp.project_role_id = 1
37: AND ppp.resource_type_id = 101
38: AND ppp.resource_source_id = pe.person_id
39: AND TRUNC(SYSDATE) BETWEEN pe.effective_start_date AND pe.effective_end_date
40: AND ppp.object_type = 'PA_PROJECTS'
41: AND TRUNC(SYSDATE) BETWEEN ppp.start_date_active
42: AND NVL(ppp.end_date_active,TRUNC(SYSDATE)+1);
43:
44: PROCEDURE Start_Dctn_Aprv_Wf (p_dctn_req_id IN NUMBER