APPS.PA_MC_BILLING_PUB dependencies on PA_PROJECTS_ALL

Line 60: FROM pa_projects_all

56:
57:
58: SELECT project_id
59: INTO l_project_id
60: FROM pa_projects_all
61: WHERE segment1 = p_project_number;
62:
63:
64: END IF;

Line 195: FROM pa_projects_all

191: IF (l_project_id IS NULL) AND (p_project_number IS NOT NULL) THEN
192:
193: SELECT project_id
194: INTO l_project_id
195: FROM pa_projects_all
196: WHERE segment1 = p_project_number;
197:
198: END IF;
199:

Line 301: FROM pa_projects_all

297: IF (l_project_id IS NULL) AND (p_project_number IS NOT NULL) THEN
298:
299: SELECT project_id
300: INTO l_project_id
301: FROM pa_projects_all
302: WHERE segment1 = p_project_number;
303:
304: END IF;
305:

Line 410: FROM pa_projects_all

406: IF (l_project_id IS NULL) AND (p_project_number IS NOT NULL) THEN
407:
408: SELECT project_id
409: INTO l_project_id
410: FROM pa_projects_all
411: WHERE segment1 = p_project_number;
412:
413: END IF;
414:

Line 518: FROM pa_projects_all

514: IF (l_project_id IS NULL) AND (p_project_number IS NOT NULL) THEN
515:
516: SELECT project_id
517: INTO l_project_id
518: FROM pa_projects_all
519: WHERE segment1 = p_project_number;
520:
521: END IF;
522: