APPS.CS_SR_INTERFACE_CP dependencies on PA_PROJECTS_ALL

Line 187: (SELECT segment1 from pa_projects_all pp where pp.project_id =ced.project_id ) ProjectNumber,

183: ced.estimate_detail_id,
184: ced.source_code,
185: ced.source_id,
186: ced.expenditure_org_id,
187: (SELECT segment1 from pa_projects_all pp where pp.project_id =ced.project_id ) ProjectNumber,
188: (SELECT task_number from pa_tasks pt where pt.task_id =ced.project_task_id ) ProjectTaskNumber,
189: csd.org_id,
190: cia.incident_number
191: FROM cs_cost_details csd,

Line 683: FROM pa_projects_all

679: Begin
680:
681: SELECT segment1
682: INTO l_project_num
683: FROM pa_projects_all
684: WHERE project_id = (select project_id from cs_estimate_details where estimate_detail_id =l_estimate_detail_id );
685:
686: Exception
687: WHEN TOO_MANY_ROWS THEN

Line 868: FROM PA_PROJECTS_ALL

864: Begin
865:
866: select projfunc_currency_code
867: INTO l_project_currency
868: FROM PA_PROJECTS_ALL
869: WHERE project_id = l_project_id;
870:
871: Exception
872: WHEN TOO_MANY_ROWS THEN