APPS.PA_PWP_NOTIFICATION dependencies on PA_PROJECTS

Line 72: FROM pa_projects

68: ,completion_date End_Date
69: ,project_type Project_Type
70: ,carrying_out_organization_id Organization_Id
71: ,project_status_code Project_Status
72: FROM pa_projects
73: WHERE segment1 = p_project_num;
74:
75: /* This subprogram will generate the html page for notification message */
76: PROCEDURE Generate_PWP_Notify_Page (p_item_type IN VARCHAR2,

Line 107: AND ppp.object_type = 'PA_PROJECTS'

103: AND ppp.project_role_id = 1
104: AND ppp.resource_type_id = 101
105: AND ppp.resource_source_id = pe.person_id
106: AND TRUNC(SYSDATE) BETWEEN pe.effective_start_date AND pe.effective_end_date
107: AND ppp.object_type = 'PA_PROJECTS'
108: AND TRUNC(SYSDATE) BETWEEN ppp.start_date_active AND NVL(ppp.end_date_active,TRUNC(SYSDATE)+1);
109:
110: END PA_PWP_NOTIFICATION;