APPS.IEC_VALIDATE_PVT dependencies on IEC_G_LIST_SUBSETS

Line 6010: FROM IEC_G_SUBSET_RT_INFO A, IEC_G_LIST_SUBSETS B

6006: , A.LOAD_PRIORITY
6007:
6008: , NVL(B.DEFAULT_SUBSET_FLAG, 'N') SUBSET_FLAG
6009:
6010: FROM IEC_G_SUBSET_RT_INFO A, IEC_G_LIST_SUBSETS B
6011:
6012: WHERE A.LIST_SUBSET_ID = B.LIST_SUBSET_ID
6013:
6014: AND B.LIST_HEADER_ID = p_list_id

Line 6080: FROM IEC_G_LIST_SUBSETS

6076: , LOAD_PRIORITY
6077:
6078: , NVL(DEFAULT_SUBSET_FLAG, 'N') SUBSET_FLAG
6079:
6080: FROM IEC_G_LIST_SUBSETS
6081:
6082: WHERE LIST_HEADER_ID = p_list_id
6083:
6084: AND STATUS_CODE <> 'DELETED'

Line 10969: IEC_G_LIST_SUBSETS D

10965:
10966: SELECT SUM(NVL(A.RECORD_LOADED, 0))
10967: into l_valid_count
10968: FROM IEC_G_REP_SUBSET_COUNTS A,
10969: IEC_G_LIST_SUBSETS D
10970: where A.SUBSET_ID = D.LIST_SUBSET_ID AND
10971: D.LIST_HEADER_ID = p_list_id AND D.STATUS_CODE <> 'DELETED';
10972:
10973:

Line 16058: 'UPDATE IEC_G_LIST_SUBSETS

16054: -- Assign load priorities to subsets
16055:
16056: EXECUTE IMMEDIATE
16057:
16058: 'UPDATE IEC_G_LIST_SUBSETS
16059:
16060: SET LOAD_PRIORITY = ROWNUM
16061:
16062: WHERE LIST_HEADER_ID = :1