DBA Data[Home] [Help]

APPS.CS_SR_INTERFACE_CP dependencies on PA_TASKS

Line 188: (SELECT task_number from pa_tasks pt where pt.task_id =ced.project_task_id ) ProjectTaskNumber,

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,
192: cs_estimate_details ced,

Line 753: FROM pa_tasks where task_id = (select project_task_id from cs_estimate_details where estimate_detail_id =l_estimate_detail_id );

749: Begin
750:
751: SELECT task_number
752: INTO l_task_num
753: FROM pa_tasks where task_id = (select project_task_id from cs_estimate_details where estimate_detail_id =l_estimate_detail_id );
754: Exception
755: WHEN TOO_MANY_ROWS THEN
756: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
757: THEN