DBA Data[Home] [Help]

APPS.AR_CASH_RECEIPT_PRINT_PKG dependencies on AR_IL_CASH_RECEIPTS_GT

Line 54: DELETE FROM AR_IL_CASH_RECEIPTS_GT;

50: ln_conc_program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
51: ln_request_id fnd_concurrent_requests.request_id%TYPE;
52: BEGIN
53: /* Added for bug 7278191 */
54: DELETE FROM AR_IL_CASH_RECEIPTS_GT;
55:
56: COMMIT;
57:
58: MO_GLOBAL.init('AR');

Line 136: l_stmt := 'INSERT INTO AR_IL_CASH_RECEIPTS_GT(

132: l_cp_orig_select := ''''||l_copy_string||''' ORIG_COPY';
133: END IF;
134:
135: /* populate gt table */
136: l_stmt := 'INSERT INTO AR_IL_CASH_RECEIPTS_GT(
137: CASH_RECEIPT_ID
138: ,RECEIPT_NUMBER
139: ,RECEIPT_DATE
140: ,RECEIPT_STATUS

Line 241: FROM AR_IL_CASH_RECEIPTS_GT);

237:
238: UPDATE ar_cash_receipts_all
239: SET global_attribute20 = 'Printed'
240: WHERE cash_receipt_id in (SELECT cash_receipt_id
241: FROM AR_IL_CASH_RECEIPTS_GT);
242:
243:
244:
245: