APPS.CS_SR_INTERFACE_CP dependencies on CSF_DEBRIEF_LINES

Line 481: FROM csf_debrief_lines cdl,

477: Else -- for a debrief line we need to get the technicians name
478:
479: SELECT pap.employee_number
480: INTO l_employee_num
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 ,

Line 1221: FROM csf_debrief_lines cdl,

1217: SELECT fu.person_party_id
1218: -- jrr.user_id,
1219: -- fu.user_name
1220: INTO l_person_id
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