DBA Data[Home] [Help]

APPS.AP_BANK_CHARGE_PKG dependencies on AP_INV_SELECTION_CRITERIA_ALL

Line 1462: FROM ap_inv_selection_criteria_ALL AISC,

1458:
1459: /* Commented for bug#12769134 Start
1460: SELECT AISC.transfer_priority
1461: INTO p_transfer_priority
1462: FROM ap_inv_selection_criteria_ALL AISC,
1463: iby_hook_docs_in_pmt_t IBY
1464: WHERE IBY.CALLING_APP_DOC_UNIQUE_REF1 = AISC.CHECKRUN_ID
1465: and rownum=1;
1466: Commented for bug#12769134 End */

Line 1471: FROM AP_INV_SELECTION_CRITERIA_ALL AISC

1467:
1468: /* Added for bug#12769134 Start */
1469: SELECT /*+ FIRST_ROWS */ AISC.TRANSFER_PRIORITY
1470: INTO p_transfer_priority
1471: FROM AP_INV_SELECTION_CRITERIA_ALL AISC
1472: WHERE EXISTS
1473: ( SELECT 1
1474: FROM IBY_HOOK_DOCS_IN_PMT_T IBY
1475: WHERE IBY.CALLING_APP_DOC_UNIQUE_REF1 = AISC.CHECKRUN_ID