APPS.CSM_DEBRIEF_LABOR_PKG dependencies on CSF_M_DEBRIEF_LABOR_INQ

Line 19: FROM csf_m_debrief_labor_inq

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

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

491: x_return_status := FND_API.G_RET_STS_SUCCESS;
492:
493: /*** loop through debrief labor records in inqueue ***/
494: IF p_task_assignment_id IS NULL THEN
495: OPEN c_cur FOR 'SELECT * FROM csf_m_debrief_labor_inq inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name
496: ||''' AND TASK_ASSIGNMENT_ID NOT IN ('||CSM_UTIL_PKG.get_String_fromList(g_processed_assignment_list)||')';
497: ELSE
498: g_processed_assignment_list(g_processed_assignment_list.COUNT+1):=p_task_assignment_id;
499: OPEN c_cur FOR 'SELECT * FROM csf_m_debrief_labor_inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name

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

495: OPEN c_cur FOR 'SELECT * FROM csf_m_debrief_labor_inq inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name
496: ||''' AND TASK_ASSIGNMENT_ID NOT IN ('||CSM_UTIL_PKG.get_String_fromList(g_processed_assignment_list)||')';
497: ELSE
498: g_processed_assignment_list(g_processed_assignment_list.COUNT+1):=p_task_assignment_id;
499: OPEN c_cur FOR 'SELECT * FROM csf_m_debrief_labor_inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name
500: ||''' AND TASK_ASSIGNMENT_ID='||p_task_assignment_id;
501: END IF;
502:
503: LOOP