eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_SR_INTERFACE_CP dependencies on FND_USER

Line 470: fnd_user fu ,

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
474: AND ced.estimate_detail_id = l_estimate_detail_id

Line 485: fnd_user fu ,

481: FROM csf_debrief_lines cdl,
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

Line 1205: The person_id is obtained by looking at the source Code on the cost record. For FS lines, the resource id can be found from there, and then trace back to the fnd user and then the person_id

1201: /*Parameter #73
1202: PERSON_ID
1203:
1204: For service ,we will provide this value for labor and expense lines- either internal employee or contingent workers
1205: The person_id is obtained by looking at the source Code on the cost record. For FS lines, the resource id can be found from there, and then trace back to the fnd user and then the person_id
1206: For charge line, use the created by user id and then find the fnd_user to find the person_id.
1207: */
1208:
1209: --Person Id is populated only when the ExpType Class is not equal to SUPPLIER INVOICES

Line 1206: For charge line, use the created by user id and then find the fnd_user to find the person_id.

1202: PERSON_ID
1203:
1204: For service ,we will provide this value for labor and expense lines- either internal employee or contingent workers
1205: The person_id is obtained by looking at the source Code on the cost record. For FS lines, the resource id can be found from there, and then trace back to the fnd user and then the person_id
1206: For charge line, use the created by user id and then find the fnd_user to find the person_id.
1207: */
1208:
1209: --Person Id is populated only when the ExpType Class is not equal to SUPPLIER INVOICES
1210:

Line 1225: fnd_user fu

1221: FROM csf_debrief_lines cdl,
1222: csf_debrief_headers cdh,
1223: jtf_task_assignments jta,
1224: jtf_rs_resource_extns jrr,
1225: fnd_user fu
1226: WHERE cdh.task_assignment_id = jta.task_assignment_id
1227: AND cdl.debrief_header_id = cdh.debrief_header_id
1228: AND cdl.debrief_line_id = l_estimate_Detail_id -- this needs to be changed
1229: AND jrr.resource_id = jta.resource_id

Line 1235: fnd_user fu

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:
1239:

Line 1243: fnd_user fu ,

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
1247: AND ced.estimate_detail_id = l_estimate_Detail_id-- this needs to be changed

Line 1363: fnd_user fu ,

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