225: ,TRANS_ID IN NUMBER) RETURN DATE IS
226: V_INVOICE_ID AP_INVOICES.INVOICE_ID%TYPE;
227: V_INVOICE_DATE AP_INVOICES.INVOICE_NUM%TYPE;
228: V_INVOICE_NUM AP_INVOICES.INVOICE_NUM%TYPE;
229: V_CHECK_ID AP_CHECKS.CHECK_ID%TYPE;
230: V_CHECK_DATE AP_CHECKS.CHECK_DATE%TYPE;
231: V_CHECK_NUMBER AP_CHECKS.CHECK_NUMBER%TYPE;
232: V_TRANS_TYPE VARCHAR2(25);
233: CURSOR C_INV_REL_AWT IS
226: V_INVOICE_ID AP_INVOICES.INVOICE_ID%TYPE;
227: V_INVOICE_DATE AP_INVOICES.INVOICE_NUM%TYPE;
228: V_INVOICE_NUM AP_INVOICES.INVOICE_NUM%TYPE;
229: V_CHECK_ID AP_CHECKS.CHECK_ID%TYPE;
230: V_CHECK_DATE AP_CHECKS.CHECK_DATE%TYPE;
231: V_CHECK_NUMBER AP_CHECKS.CHECK_NUMBER%TYPE;
232: V_TRANS_TYPE VARCHAR2(25);
233: CURSOR C_INV_REL_AWT IS
234: SELECT
227: V_INVOICE_DATE AP_INVOICES.INVOICE_NUM%TYPE;
228: V_INVOICE_NUM AP_INVOICES.INVOICE_NUM%TYPE;
229: V_CHECK_ID AP_CHECKS.CHECK_ID%TYPE;
230: V_CHECK_DATE AP_CHECKS.CHECK_DATE%TYPE;
231: V_CHECK_NUMBER AP_CHECKS.CHECK_NUMBER%TYPE;
232: V_TRANS_TYPE VARCHAR2(25);
233: CURSOR C_INV_REL_AWT IS
234: SELECT
235: INVOICE_DATE,
241: SELECT
242: CHECK_DATE,
243: CHECK_NUMBER
244: FROM
245: AP_CHECKS
246: WHERE CHECK_ID = V_CHECK_ID;
247: BEGIN
248: IF TRANS_TYPE = 'AWT' THEN
249: IF CP_CREATE_AWT_DISTS_TYPE = 'PAYMENT' THEN