DBA Data[Home] [Help]

APPS.AR_INVOICE_DEFAULT_PVT dependencies on AR_TRX_HEADER_GT

Line 288: FROM ar_trx_header_gt hdr,

284: if they are not supposed to post to gl */
285: CURSOR ar_invoice_gt_c IS
286: SELECT nvl(hdr.trx_date, sysdate) trx_date, hdr.set_of_books_id,
287: hdr.trx_header_id
288: FROM ar_trx_header_gt hdr,
289: ra_cust_trx_types tt
290: WHERE gl_date IS NULL
291: AND hdr.cust_trx_type_id = tt.cust_trx_type_id
292: AND NVL(tt.post_to_gl,'N') = 'Y';

Line 323: UPDATE ar_trx_header_gt

319: THEN
320: ar_invoice_utils.debug ('Default GL Date ' || l_default_gl_date);
321: END IF;
322:
323: UPDATE ar_trx_header_gt
324: SET gl_date = l_default_gl_date
325: WHERE trx_header_id = ar_invoice_gt_rec.trx_header_id;
326:
327: UPDATE ar_trx_dist_gt