APPS.CS_SR_INTERFACE_CP dependencies on PER_ALL_PEOPLE_F

Line 471: per_all_people_f pap

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
474: AND ced.estimate_detail_id = l_estimate_detail_id
475: AND to_date(ced.creation_date) between nvl(pap.effective_start_date,sysdate) and nvl(pap.effective_end_date,sysdate);

Line 486: PER_ALL_PEOPLE_F pap

482: csf_debrief_headers cdh,
483: jtf_task_assignments jta,
484: jtf_rs_resource_extns jrr,
485: fnd_user fu ,
486: PER_ALL_PEOPLE_F pap
487: WHERE cdh.task_assignment_id = jta.task_assignment_id
488: AND cdl.debrief_header_id = cdh.debrief_header_id
489: AND cdl.debrief_line_id = l_source_id
490: AND jrr.resource_id = jta.resource_id

Line 1244: per_all_people_f pap

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
1247: AND ced.estimate_detail_id = l_estimate_Detail_id-- this needs to be changed
1248: AND ced.creation_date between nvl(pap.effective_start_date,sysdate) and nvl(pap.effective_end_date,sysdate);

Line 1364: PER_ALL_PEOPLE_F pap

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
1367: AND ced.estimate_detail_id = l_estimate_detail_id and rownum=1;
1368: