APPS.CE_CEXCLEAR_XMLP_PKG dependencies on AP_CHECKS

Line 114: AP_CHECKS C

110: INTO
111: C_BATCH_AMOUNT
112: ,C_BATCH_BANK_ACCOUNT_AMOUNT
113: FROM
114: AP_CHECKS C
115: WHERE C.CHECKRUN_NAME = BATCH_NUMBER;
116: SELECT
117: SUM(NVL(C.CLEARED_AMOUNT
118: ,0))

Line 122: AP_CHECKS C

118: ,0))
119: INTO
120: C_BATCH_CLEARED_AMOUNT
121: FROM
122: AP_CHECKS C
123: WHERE C.CHECKRUN_NAME = BATCH_NUMBER
124: AND C.CLEARED_DATE is not NULL;
125: EXCEPTION
126: WHEN NO_DATA_FOUND THEN