APPS.CSF_DEBRIEF_PVT dependencies on JTF_TASK_STATUSES_B

Line 1003: from jtf_task_statuses_b jtsb,

999: select greatest(nvl(rejected_flag,'N'),
1000: nvl(completed_flag,'N'),
1001: nvl(closed_flag,'N'),
1002: nvl(cancelled_flag,'N'))
1003: from jtf_task_statuses_b jtsb,
1004: jtf_task_assignments jta,
1005: csf_debrief_headers cdh
1006: where cdh.debrief_header_id = p_debrief_header_id
1007: and jta.task_assignment_id = cdh.task_assignment_id

Line 1869: from jtf_task_statuses_b jtsb,

1865: select greatest(nvl(rejected_flag,'N'),
1866: nvl(completed_flag,'N'),
1867: nvl(closed_flag,'N'),
1868: nvl(cancelled_flag,'N'))
1869: from jtf_task_statuses_b jtsb,
1870: jtf_task_assignments jta,
1871: csf_debrief_headers cdh
1872: where cdh.debrief_header_id = p_debrief_header_id
1873: and jta.task_assignment_id = cdh.task_assignment_id

Line 3397: jtf_task_statuses_b jtsbnew,

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
3401: and jtaab.old_assignment_status_id <> jtaab.new_assignment_status_id

Line 3398: jtf_task_statuses_b jtsbold

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
3401: and jtaab.old_assignment_status_id <> jtaab.new_assignment_status_id
3402: and jtaab.assignment_id = p_task_assignment_id

Line 3410: jtf_task_statuses_b jtsbnew,

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
3414: and jtaab.old_assignment_status_id <> jtaab.new_assignment_status_id

Line 3411: jtf_task_statuses_b jtsbold

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
3414: and jtaab.old_assignment_status_id <> jtaab.new_assignment_status_id
3415: and jtaab.assignment_id = p_task_assignment_id

Line 3420: from jtf_task_statuses_b

3416: order by jtaab.creation_date desc;
3417:
3418: cursor c_working_flag is
3419: select working_flag,travel_flag
3420: from jtf_task_statuses_b
3421: where task_status_id = l_assignment_status_id;
3422:
3423: cursor c_task_type_rule is
3424: select jttb.rule

Line 3433: jtf_task_statuses_b jtsb

3429:
3430: cursor c_any_working_task is
3431: select 'Y'
3432: from jtf_task_assignments jta,
3433: jtf_task_statuses_b jtsb
3434: where assignee_role = 'ASSIGNEE'
3435: and resource_type_code = l_resource_type_code
3436: and resource_id = l_resource_id
3437: and jtsb.task_status_id = jta.assignment_status_id

Line 3676: jtf_task_statuses_b jtsb

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';
3680: