APPS.IEC_VALIDATE_PVT dependencies on IEC_G_LIST_SUBSETS

Line 6032: FROM IEC_G_SUBSET_RT_INFO A, IEC_G_LIST_SUBSETS B

6028: , A.LOAD_PRIORITY
6029:
6030: , NVL(B.DEFAULT_SUBSET_FLAG, 'N') SUBSET_FLAG
6031:
6032: FROM IEC_G_SUBSET_RT_INFO A, IEC_G_LIST_SUBSETS B
6033:
6034: WHERE A.LIST_SUBSET_ID = B.LIST_SUBSET_ID
6035:
6036: AND B.LIST_HEADER_ID = p_list_id

Line 6102: FROM IEC_G_LIST_SUBSETS

6098: , LOAD_PRIORITY
6099:
6100: , NVL(DEFAULT_SUBSET_FLAG, 'N') SUBSET_FLAG
6101:
6102: FROM IEC_G_LIST_SUBSETS
6103:
6104: WHERE LIST_HEADER_ID = p_list_id
6105:
6106: AND STATUS_CODE <> 'DELETED'

Line 10991: IEC_G_LIST_SUBSETS D

10987:
10988: SELECT SUM(NVL(A.RECORD_LOADED, 0))
10989: into l_valid_count
10990: FROM IEC_G_REP_SUBSET_COUNTS A,
10991: IEC_G_LIST_SUBSETS D
10992: where A.SUBSET_ID = D.LIST_SUBSET_ID AND
10993: D.LIST_HEADER_ID = p_list_id AND D.STATUS_CODE <> 'DELETED';
10994:
10995:

Line 16080: 'UPDATE IEC_G_LIST_SUBSETS

16076: -- Assign load priorities to subsets
16077:
16078: EXECUTE IMMEDIATE
16079:
16080: 'UPDATE IEC_G_LIST_SUBSETS
16081:
16082: SET LOAD_PRIORITY = ROWNUM
16083:
16084: WHERE LIST_HEADER_ID = :1