APPS.CSM_DEBRIEF_EXPENSES_PKG dependencies on CSF_M_DEBRIEF_EXPENSES_INQ

Line 19: FROM csf_m_debrief_expenses_inq

15: g_processed_assignment_list ASG_DOWNLOAD.ACCESS_LIST;
16:
17: CURSOR c_debrief_expenses( b_user_name VARCHAR2, b_tranid NUMBER) is
18: SELECT *
19: FROM csf_m_debrief_expenses_inq
20: WHERE tranid$$ = b_tranid
21: AND clid$$cs = b_user_name;
22:
23: /***

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

500: csm_util_pkg.log('csm_debrief_expenses_pkg.apply_client_changes entered','CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);
501:
502: /*** loop through debrief expenses records in inqueue ***/
503: IF p_task_assignment_id IS NULL THEN
504: OPEN c_cur FOR 'SELECT * FROM csf_m_debrief_expenses_inq inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name
505: ||''' AND TASK_ASSIGNMENT_ID NOT IN ('||CSM_UTIL_PKG.get_String_fromList(g_processed_assignment_list)||')';
506: ELSE
507: g_processed_assignment_list(g_processed_assignment_list.COUNT+1):=p_task_assignment_id;
508: OPEN c_cur FOR 'SELECT * FROM csf_m_debrief_expenses_inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name

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

504: OPEN c_cur FOR 'SELECT * FROM csf_m_debrief_expenses_inq inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name
505: ||''' AND TASK_ASSIGNMENT_ID NOT IN ('||CSM_UTIL_PKG.get_String_fromList(g_processed_assignment_list)||')';
506: ELSE
507: g_processed_assignment_list(g_processed_assignment_list.COUNT+1):=p_task_assignment_id;
508: OPEN c_cur FOR 'SELECT * FROM csf_m_debrief_expenses_inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name
509: ||''' AND TASK_ASSIGNMENT_ID='||p_task_assignment_id;
510: END IF;
511:
512: LOOP