APPS.CS_SR_INTERFACE_CP dependencies on CS_ESTIMATE_DETAILS

Line 192: cs_estimate_details ced,

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,
193: cs_txn_billing_types ctb,
194: cs_incidents_all_b cia
195: WHERE cia.incident_id = ced.incident_id
196: AND ced.estimate_detail_id = csd.estimate_detail_id

Line 465: If l_source_code ='SR' THEN -- pass the created_by in the cs_estimate_details table to fetch the employee number

461:
462:
463: Begin
464:
465: If l_source_code ='SR' THEN -- pass the created_by in the cs_estimate_details table to fetch the employee number
466:
467: SELECT pap.employee_number
468: INTO l_employee_num
469: FROM cs_estimate_details ced,

Line 469: FROM cs_estimate_details ced,

465: If l_source_code ='SR' THEN -- pass the created_by in the cs_estimate_details table to fetch the employee number
466:
467: SELECT pap.employee_number
468: INTO l_employee_num
469: FROM cs_estimate_details ced,
470: fnd_user fu ,
471: per_all_people_f pap
472: WHERE ced.created_by = fu.user_id
473: AND pap.person_id = fu.employee_id

Line 591: WHERE organization_id = (select expenditure_org_id from cs_estimate_details where estimate_detail_id =l_estimate_detail_id );

587: BEGIN
588: SELECT name
589: INTO l_organization_name
590: FROM hr_all_organization_units --need to clarify whether to use hr_organization_units
591: WHERE organization_id = (select expenditure_org_id from cs_estimate_details where estimate_detail_id =l_estimate_detail_id );
592:
593: Exception
594: WHEN TOO_MANY_ROWS THEN
595: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

Line 684: WHERE project_id = (select project_id from cs_estimate_details where estimate_detail_id =l_estimate_detail_id );

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
688: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

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

Line 1234: FROM cs_estimate_details ced,

1230: AND fu.user_id = jrr.user_id ;
1231: Else
1232: /*SELECT fu.person_party_id
1233: INTO l_person_id
1234: FROM cs_estimate_details ced,
1235: fnd_user fu
1236: WHERE ced.created_by = fu.user_id
1237: AND ced.estimate_detail_id = l_estimate_Detail_id;-- this needs to be changed*/
1238:

Line 1242: FROM cs_estimate_details ced,

1238:
1239:
1240: SELECT pap.person_id
1241: INTO l_person_id
1242: FROM cs_estimate_details ced,
1243: fnd_user fu ,
1244: per_all_people_f pap
1245: WHERE ced.created_by = fu.user_id
1246: AND pap.party_id = fu.person_party_id

Line 1362: FROM cs_estimate_details ced,

1358: Begin
1359:
1360: SELECT pap. business_group_id
1361: into l_business_group_id
1362: FROM cs_estimate_details ced,
1363: fnd_user fu ,
1364: PER_ALL_PEOPLE_F pap
1365: WHERE ced.created_by = fu.user_id
1366: AND pap.person_id = fu.employee_id