APPS.CSF_DEBRIEF_PVT dependencies on JTF_TASK_ASSIGNMENTS_AUDIT_B

Line 3396: from jtf_task_assignments_audit_b jtaab,

3392: cursor c_audit_travel(p_task_assignment_id number) is
3393: select jtsbold.travel_flag old_travel_flag,
3394: jtsbnew.travel_flag new_travel_flag,
3395: trunc(jtaab.creation_date,'MI') creation_date
3396: from jtf_task_assignments_audit_b jtaab,
3397: jtf_task_statuses_b jtsbnew,
3398: jtf_task_statuses_b jtsbold
3399: where jtsbold.task_status_id = jtaab.old_assignment_status_id
3400: and jtsbnew.task_status_id = jtaab.new_assignment_status_id

Line 3409: from jtf_task_assignments_audit_b jtaab,

3405: cursor c_audit_working(p_task_assignment_id number) is
3406: select jtsbold.working_flag old_working_flag,
3407: jtsbnew.working_flag new_working_flag,
3408: trunc(jtaab.creation_date,'MI') creation_date
3409: from jtf_task_assignments_audit_b jtaab,
3410: jtf_task_statuses_b jtsbnew,
3411: jtf_task_statuses_b jtsbold
3412: where jtsbold.task_status_id = jtaab.old_assignment_status_id
3413: and jtsbnew.task_status_id = jtaab.new_assignment_status_id

Line 3675: from jtf_task_assignments_audit_b jtaab,

3671:
3672: cursor c_labor_auto_create is
3673: select decode(fnd_profile.value('CSF_DEFAULT_LABOR_DEBRIEF_DATETIME'),
3674: 'STATUS',jtsb.working_flag,'N')
3675: from jtf_task_assignments_audit_b jtaab,
3676: jtf_task_statuses_b jtsb
3677: where jtsb.task_status_id = jtaab.new_assignment_status_id
3678: and jtaab.assignment_id = p_task_assignment_id
3679: and jtsb.working_flag = 'Y';