APPS.AP_APXKIRKI_XMLP_PKG dependencies on AP_VENDOR_KEY_IND

Line 1342: INSERT INTO AP_VENDOR_KEY_IND

1338: ,C_NEW_AMOUNT
1339: ,C_MH_COUNT
1340: ,C_MH_AMOUNT
1341: ,C_ORG_ID);
1342: INSERT INTO AP_VENDOR_KEY_IND
1343: (PERIOD_NAME
1344: ,LAST_UPDATE_DATE
1345: ,LAST_UPDATED_BY
1346: ,NUM_VENDORS

Line 1449: AP_VENDOR_KEY_IND

1445: ,NUM_INVOICES_MATCH_HOLD = C_MH_COUNT
1446: ,AMOUNT_INVOICES_MATCH_HOLD = C_MH_AMOUNT
1447: WHERE PERIOD_NAME = P_PERIOD_NAME;
1448: UPDATE
1449: AP_VENDOR_KEY_IND
1450: SET
1451: LAST_UPDATE_DATE = SYSDATE
1452: ,LAST_UPDATED_BY = 0
1453: ,NUM_VENDORS = C_NEW_VENDORS

Line 1591: AP_VENDOR_KEY_IND VEN,

1587: L_OLD_AUTO_CHECKS_DLR,L_OLD_MANUAL_CHECKS_DLR,L_OLD_DISCOUNTS,L_OLD_DISCOUNT_DLR,L_OLD_VOID,L_OLD_STOPPED,
1588: L_OLD_SPOILED,L_OLD_OUTSTANDING,L_OLD_CLEARED,L_OLD_CLEARED_DLR,L_OLD_OUTSTANDING_DLR,L_OLD_REFUND_PAYMENTS,L_OLD_REFUND_PAYMENTS_DLR
1589: FROM
1590: AP_INVOICE_KEY_IND INV,
1591: AP_VENDOR_KEY_IND VEN,
1592: AP_PAYMENT_KEY_IND PAY
1593: WHERE INV.PERIOD_NAME = VEN.PERIOD_NAME
1594: AND INV.PERIOD_NAME = PAY.PERIOD_NAME
1595: AND INV.PERIOD_NAME = C_PRIOR_PERIOD_NAME;