APPS.AP_APXWTGNR_XMLP_PKG dependencies on AP_CHECKS

Line 454: AP_CHECKS

450: CURSOR C_CHECKRUN_OK IS
451: SELECT
452: 'Checkrun_Name exists'
453: FROM
454: AP_CHECKS
455: WHERE ( CHECKRUN_NAME = P_CHECKRUN_NAME );
456: REC_CHECKRUN_OK C_CHECKRUN_OK%ROWTYPE;
457: ROW_FOUND BOOLEAN;
458: BEGIN

Line 862: AP_CHECKS C,

858: CURSOR C_PAYMENT_DATE IS
859: SELECT
860: C.CHECK_DATE PAYMENT_DATE
861: FROM
862: AP_CHECKS C,
863: AP_INVOICE_PAYMENTS P
864: WHERE ( C.CHECK_ID = P.CHECK_ID )
865: AND ( P.INVOICE_ID = CLASTPAYMENTDATE.INVOICE_ID )
866: AND ( P.INVOICE_PAYMENT_ID = NVL(BREAK_AWT_PAYMENT_ID

Line 1244: ' || ' , ap_checks ' || ' t_auth_checks' || '

1240: RET_TEXT := 'and exists' || '
1241: ' || ' (' || '
1242: ' || ' select ''Distribution already paid to ' || 'the tax authority''' || '
1243: ' || ' from ap_invoice_payments' || ' t_auth_payments' || '
1244: ' || ' , ap_checks ' || ' t_auth_checks' || '
1245: ' || ' where t_auth_checks.checkrun_name = ' || ':P_Checkrun_Name' || '
1246: ' || ' and t_auth_checks.check_id = ' || 't_auth_payments.check_id' || '
1247: ' || ' and d.awt_invoice_id = ' || 't_auth_payments.invoice_id' || '
1248: ' || ' )';

Line 1332: AP_CHECKS C,

1328: CURSOR C_PAYMENT_DOC IS
1329: SELECT
1330: C.CHECK_NUMBER PAYMENT_DOC
1331: FROM
1332: AP_CHECKS C,
1333: AP_INVOICE_PAYMENTS P
1334: WHERE ( C.CHECK_ID = P.CHECK_ID )
1335: AND ( P.INVOICE_ID = INVOICE_ID )
1336: AND ( P.INVOICE_PAYMENT_ID = NVL(BREAK_AWT_PAYMENT_ID