APPS.IEC_RLCTRL_PVT dependencies on AMS_LIST_ENTRIES

Line 24: FROM AMS_LIST_ENTRIES

20: IF P_DNU_REASON_CODE IS NOT NULL THEN
21:
22: SELECT LIST_ENTRY_ID
23: BULK COLLECT INTO L_LIST_ENTRY_IDS
24: FROM AMS_LIST_ENTRIES
25: WHERE LIST_HEADER_ID = P_LIST_HEADER_ID AND DO_NOT_USE_FLAG = 'Y' AND DO_NOT_USE_REASON = P_DNU_REASON_CODE;
26:
27: ELSE
28:

Line 31: FROM AMS_LIST_ENTRIES

27: ELSE
28:
29: SELECT LIST_ENTRY_ID
30: BULK COLLECT INTO L_LIST_ENTRY_IDS
31: FROM AMS_LIST_ENTRIES
32: WHERE LIST_HEADER_ID = P_LIST_HEADER_ID AND DO_NOT_USE_FLAG = 'Y';
33:
34: END IF;
35:

Line 39: UPDATE AMS_LIST_ENTRIES

35:
36: IF L_LIST_ENTRY_IDS IS NOT NULL AND L_LIST_ENTRY_IDS.COUNT > 0 THEN
37:
38: FORALL I IN L_LIST_ENTRY_IDS.FIRST..L_LIST_ENTRY_IDS.LAST
39: UPDATE AMS_LIST_ENTRIES
40: SET DO_NOT_USE_FLAG = 'N'
41: WHERE LIST_ENTRY_ID = L_LIST_ENTRY_IDS(I);
42:
43: FORALL I IN L_LIST_ENTRY_IDS.FIRST..L_LIST_ENTRY_IDS.LAST