APPS.CE_CSH_FCST_POP dependencies on PA_PROJECTS_ALL

Line 2421: pa_projects_all pa

2417: IF (CE_CASH_FCST.G_rp_project_id IS NOT NULL) THEN
2418: where_clause := where_clause || '
2419: AND src.customer_trx_id IN (select ctl.customer_trx_id
2420: from ra_customer_trx_lines_all ctl,
2421: pa_projects_all pa
2422: where ctl.interface_line_attribute1 = pa.segment1
2423: and pa.project_id = ' || to_char(CE_CASH_FCST.G_rp_project_id) || ')';
2424:
2425: END IF;

Line 5054: FROM pa_projects_all

5050: ||', CE_CASH_FCST.G_overdue_column_id ='||CE_CASH_FCST.G_overdue_column_id );
5051:
5052: SELECT org_id
5053: INTO l_org_id
5054: FROM pa_projects_all
5055: WHERE project_id = CE_CASH_FCST.G_rp_project_id;
5056:
5057: SELECT to_number(ORGANIZATION_ID)
5058: INTO l_legal_entity_id