APPS.CSP_PARTS_REQUIREMENT dependencies on JTF_TASK_STATUSES_B

Line 3924: FROM JTF_TASK_STATUSES_B

3920: end if;
3921:
3922: SELECT nvl(cancelled_flag, 'N')
3923: INTO l_o_assg_sts_flag
3924: FROM JTF_TASK_STATUSES_B
3925: WHERE task_status_id = g_old_tsk_asgn_sts_id;
3926:
3927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3937: FROM JTF_TASK_STATUSES_B

3933: if l_o_assg_sts_flag = 'Y' then
3934:
3935: SELECT decode(count(*), 1, 'Y', 'N')
3936: INTO l_assg_sts_flag
3937: FROM JTF_TASK_STATUSES_B
3938: WHERE task_status_id = l_assignment_status_id
3939: and (nvl(assigned_flag, 'N') = 'Y'
3940: or nvl(accepted_flag, 'N') = 'Y' or nvl(planned_flag, 'N') = 'Y');
3941:

Line 3974: FROM JTF_TASK_STATUSES_B

3970: end if;
3971:
3972: SELECT nvl(accepted_flag, 'N')
3973: INTO l_assg_sts_flag
3974: FROM JTF_TASK_STATUSES_B
3975: WHERE task_status_id = l_assignment_status_id;
3976:
3977: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3978: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 4050: FROM JTF_TASK_STATUSES_B

4046: end if;
4047:
4048: SELECT nvl(cancelled_flag, 'N')
4049: INTO l_assg_sts_flag
4050: FROM JTF_TASK_STATUSES_B
4051: WHERE task_status_id = l_assignment_status_id;
4052:
4053: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4054: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,