DBA Data[Home] [Help]

APPS.CSM_MULTI_MOBQRY_PKG dependencies on JTF_TASK_STATUSES_TL

Line 1871: SELECT name FROM JTF_TASK_STATUSES_TL WHERE TASK_STATUS_ID=to_number(P_TA_ST_ID)

1867: FROM JTF_TASK_ASSIGNMENTS
1868: WHERE TASK_ASSIGNMENT_ID=to_number(P_TA_ID);
1869:
1870: CURSOR c_task_status IS
1871: SELECT name FROM JTF_TASK_STATUSES_TL WHERE TASK_STATUS_ID=to_number(P_TA_ST_ID)
1872: AND LANGUAGE=asg_base.get_language(p_user_name);
1873:
1874: l_user_id NUMBER;
1875: l_resp_id NUMBER;