DBA Data[Home] [Help]

APPS.CS_SR_INTERFACE_CP dependencies on JTF_TASK_ASSIGNMENTS

Line 483: jtf_task_assignments jta,

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 ,
486: PER_ALL_PEOPLE_F pap
487: WHERE cdh.task_assignment_id = jta.task_assignment_id

Line 1223: jtf_task_assignments jta,

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
1226: WHERE cdh.task_assignment_id = jta.task_assignment_id
1227: AND cdl.debrief_header_id = cdh.debrief_header_id