APPS.PA_BILLING_VALUES dependencies on PA_PROJECTS

Line 30: FROM pa_projects

26: 'Y', 'PROJECT',
27: 'N','TASK',
28: 'NO FUNDING')
29: INTO funding
30: FROM pa_projects
31: WHERE project_id = X2_project_id;
32:
33: return funding;
34: END funding_level;

Line 43: FROM pa_projects p

39: BEGIN
40: IF (X2_top_task_id IS NULL) THEN
41: SELECT p.carrying_out_organization_id
42: INTO XO_organization_id
43: FROM pa_projects p
44: WHERE p.project_id = X2_project_id;
45: ELSE
46: SELECT t.carrying_out_organization_id
47: INTO XO_organization_id