DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENTS_PKG dependencies on CSM_TASK_ASSIGNMENTS_INQ

Line 25: FROM csm_task_assignments_inq

21: g_debug_level NUMBER; -- debug level
22:
23: CURSOR c_task_assignments_inq( b_user_name VARCHAR2, b_tranid NUMBER) IS
24: SELECT *
25: FROM csm_task_assignments_inq
26: WHERE tranid$$ = b_tranid
27: AND CLID$$CS = B_USER_NAME;
28:
29: /***

Line 871: CSM_TASK_ASSIGNMENTS_INQ a

867: l_sequence in number)
868: IS
869: SELECT b.last_updated_by
870: FROM JTF_TASK_ASSIGNMENTS b,
871: CSM_TASK_ASSIGNMENTS_INQ a
872: WHERE a.clid$$cs = l_user_name
873: AND tranid$$ = l_tran_id
874: AND seqno$$ = l_sequence
875: AND a.task_assignment_id = b.task_assignment_id ;