APPS.IGIRCBAP dependencies on IGI_AR_REC_APPLICATIONS

Line 1126: igi_ar_rec_applications igi_ra,

1122: ra.acctd_amount_applied_from AcctdAmount,
1123: ra.code_combination_id CodeCombinationId,
1124: ra.status Status
1125: FROM ar_receivable_applications ra,
1126: igi_ar_rec_applications igi_ra,
1127: ar_cash_receipts cr
1128: WHERE ra.receivable_application_id = igi_ra.receivable_application_id
1129: AND igi_ra.arc_posting_control_id = p_Post.UnpostedPostingControlId
1130: AND trunc(ra.gl_date) >= p_Post.GlDateFrom

Line 1269: UPDATE igi_ar_rec_applications

1265: WritetoLog(l_excep_level, 'PostNonDistApplications','RRa.Status:'||RRa.Status );
1266: RAISE;
1267: END;
1268: --
1269: UPDATE igi_ar_rec_applications
1270: SET arc_posting_control_id = p_Post.PostingControlId,
1271: arc_gl_posted_date = p_Post.GlPostedDate
1272: WHERE rowid = RRa.IGIRaRowid;
1273:

Line 1388: igi_ar_rec_applications igira,

1384: '1', NVL(ra.receivables_charges_applied,0),
1385: '2', NVL(-ra.receivables_charges_applied,0)
1386: ) ChargesApplied
1387: FROM ar_receivable_applications ra,
1388: igi_ar_rec_applications igira,
1389: ra_cust_trx_types ctt,
1390: ra_customer_trx ct,
1391: ar_cash_receipts cr,
1392: ar_cash_receipt_history crh,

Line 1492: UPDATE igi_ar_rec_applications

1488: --
1489: IF l_Trx.CmPsIdFlag <> 'Y'
1490: THEN
1491: --
1492: UPDATE igi_ar_rec_applications
1493: SET arc_posting_control_id = p_Post.PostingControlId,
1494: arc_gl_posted_date = p_Post.GlPostedDate
1495: WHERE rowid = l_IGIRowid;
1496: --

Line 1941: UPDATE igi_ar_rec_applications igiapp

1937: --
1938: IF ( p_CategoryCode = 'TRADE') OR
1939: ( p_CategoryCode = 'CMAPP' )
1940: THEN
1941: UPDATE igi_ar_rec_applications igiapp
1942: SET arc_gl_posted_date = NULL,
1943: arc_posting_control_id = p_Post.UnpostedPostingControlId
1944: WHERE arc_posting_control_id = p_Post.PostingControlId
1945: AND EXISTS

Line 2330: , igi_ar_rec_applications igiapp

2326:
2327: SELECT nvl(max(app.receivable_application_id), 999999999999998)+1
2328: INTO l_Post.NxtReceivableApplicationId
2329: FROM ar_receivable_applications app
2330: , igi_ar_rec_applications igiapp
2331: WHERE app.receivable_application_id = igiapp.receivable_application_id
2332: AND igiapp.arc_posting_control_id = p_PostingControlId;
2333:
2334: SELECT nvl(max(mcd.misc_cash_distribution_id), 999999999999998)+1