eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 872: AP_CHECKS C,

868: CURSOR C_PAYMENT_DATE IS
869: SELECT
870: C.CHECK_DATE PAYMENT_DATE
871: FROM
872: AP_CHECKS C,
873: AP_INVOICE_PAYMENTS P
874: WHERE ( C.CHECK_ID = P.CHECK_ID )
875: AND ( P.INVOICE_ID = CLASTPAYMENTDATE.INVOICE_ID )
876: AND ( P.INVOICE_PAYMENT_ID = NVL(BREAK_AWT_PAYMENT_ID

Line 1254: ' || ' , ap_checks ' || ' t_auth_checks' || '

1250: RET_TEXT := 'and exists' || '
1251: ' || ' (' || '
1252: ' || ' select ''Distribution already paid to ' || 'the tax authority''' || '
1253: ' || ' from ap_invoice_payments' || ' t_auth_payments' || '
1254: ' || ' , ap_checks ' || ' t_auth_checks' || '
1255: ' || ' where t_auth_checks.checkrun_name = ' || ':P_Checkrun_Name' || '
1256: ' || ' and t_auth_checks.check_id = ' || 't_auth_payments.check_id' || '
1257: ' || ' and d.awt_invoice_id = ' || 't_auth_payments.invoice_id' || '
1258: ' || ' )';

Line 1342: AP_CHECKS C,

1338: CURSOR C_PAYMENT_DOC IS
1339: SELECT
1340: C.CHECK_NUMBER PAYMENT_DOC
1341: FROM
1342: AP_CHECKS C,
1343: AP_INVOICE_PAYMENTS P
1344: WHERE ( C.CHECK_ID = P.CHECK_ID )
1345: AND ( P.INVOICE_ID = INVOICE_ID )
1346: AND ( P.INVOICE_PAYMENT_ID = NVL(BREAK_AWT_PAYMENT_ID