APPS.PA_BILLING_WRKBNCH_EVENTS dependencies on PA_PROJECTS

Line 489: FROM pa_projects p, hr_organization_units o

485: SELECT to_char(o.organization_id),
486: o.name
487: INTO X_Org_ID,
488: X_Org_Name
489: FROM pa_projects p, hr_organization_units o
490: WHERE p.carrying_out_organization_id = o.organization_id
491: AND p.project_id = P_Project_ID;
492:
493: Exception WHEN OTHERS

Line 501: p_project_id IN pa_projects_all.project_id%TYPE,

497:
498:
499: Function CHECK_BILLING_EVENT_EXISTS
500: (
501: p_project_id IN pa_projects_all.project_id%TYPE,
502: p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
503: ) RETURN VARCHAR2
504: IS
505: