DBA Data[Home] [Help]

APPS.CSL_TASK_ASSIGNMENTS_PKG dependencies on CSL_JTF_TASK_ASSIGNMENTS_INQ

Line 13: FROM CSL_JTF_TASK_ASSIGNMENTS_inq

9: g_debug_level NUMBER; -- debug level
10:
11: CURSOR c_task_ass( b_user_name VARCHAR2, b_tranid NUMBER) is
12: SELECT *
13: FROM CSL_JTF_TASK_ASSIGNMENTS_inq
14: WHERE tranid$$ = b_tranid
15: AND clid$$cs = b_user_name;
16:
17: /***

Line 799: FROM JTF_TASK_ASSIGNMENTS b, CSL_JTF_TASK_ASSIGNMENTS_INQ a

795: cursor get_user_id(l_tran_id in number,
796: l_user_name in varchar2)
797: IS
798: SELECT b.last_updated_by
799: FROM JTF_TASK_ASSIGNMENTS b, CSL_JTF_TASK_ASSIGNMENTS_INQ a
800: WHERE a.clid$$cs = l_user_name
801: AND tranid$$ = l_tran_id AND a.task_assignment_id = b.task_assignment_id
802: AND a.SEQNO$$ = p_sequence;
803: