APPS.CSM_DEBRIEF_PARTS_PKG dependencies on CSF_M_DEBRIEF_PARTS_INQ

Line 20: FROM csf_m_debrief_parts_inq

16: g_processed_assignment_list ASG_DOWNLOAD.ACCESS_LIST;
17:
18: CURSOR c_debrief_parts( b_user_name VARCHAR2, b_tranid NUMBER) is
19: SELECT *
20: FROM csf_m_debrief_parts_inq
21: WHERE tranid$$ = b_tranid
22: AND clid$$cs = b_user_name;
23:
24: CURSOR c_csm_user_details(b_user VARCHAR2)

Line 963: OPEN c_cur FOR 'SELECT * FROM csf_m_debrief_parts_inq inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name

959: x_return_status := FND_API.G_RET_STS_SUCCESS;
960:
961: /*** loop through debrief parts records in inqueue ***/
962: IF p_task_assignment_id IS NULL THEN
963: OPEN c_cur FOR 'SELECT * FROM csf_m_debrief_parts_inq inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name
964: ||''' AND TASK_ASSIGNMENT_ID NOT IN ('||CSM_UTIL_PKG.get_String_fromList(g_processed_assignment_list)||')';
965: ELSE
966: g_processed_assignment_list(g_processed_assignment_list.COUNT+1):=p_task_assignment_id;
967: OPEN c_cur FOR 'SELECT * FROM csf_m_debrief_parts_inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name

Line 967: OPEN c_cur FOR 'SELECT * FROM csf_m_debrief_parts_inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name

963: OPEN c_cur FOR 'SELECT * FROM csf_m_debrief_parts_inq inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name
964: ||''' AND TASK_ASSIGNMENT_ID NOT IN ('||CSM_UTIL_PKG.get_String_fromList(g_processed_assignment_list)||')';
965: ELSE
966: g_processed_assignment_list(g_processed_assignment_list.COUNT+1):=p_task_assignment_id;
967: OPEN c_cur FOR 'SELECT * FROM csf_m_debrief_parts_inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name
968: ||''' AND TASK_ASSIGNMENT_ID='||p_task_assignment_id;
969: END IF;
970:
971: LOOP