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 557: CSM_TASK_ASSIGNMENTS_INQ a

553: l_sequence in number)
554: IS
555: SELECT b.last_updated_by
556: FROM JTF_TASK_ASSIGNMENTS b,
557: CSM_TASK_ASSIGNMENTS_INQ a
558: WHERE a.clid$$cs = l_user_name
559: AND tranid$$ = l_tran_id
560: AND seqno$$ = l_sequence
561: AND a.task_assignment_id = b.task_assignment_id ;