APPS.JL_BR_AR_REMIT_COLL_OCCUR dependencies on JL_BR_AR_COLLECTION_DOCS

Line 75: from AR_PAYMENT_SCHEDULES_ALL PS, JL_BR_AR_COLLECTION_DOCS_ALL DC,

71: JLBRRMA.INTEREST_REVENUE_RECTRX_ID,
72: JLBRRMA.ABATEMENT_WRITEOFF_RECTRX_ID,
73: JLBRRMA.ABATEMENT_REVENUE_RECTRX_ID,
74: CSC.GL_DATE
75: from AR_PAYMENT_SCHEDULES_ALL PS, JL_BR_AR_COLLECTION_DOCS_ALL DC,
76: JL_BR_AR_BORDEROS B,
77: AR_RECEIPT_METHOD_ACCOUNTS_ALL RMA,
78: JL_BR_AR_SELECT_ACCOUNTS_ALL CSC,
79: JL_BR_AR_REC_MET_ACCTS_EXT_ALL JLBRRMA,

Line 143: from AR_PAYMENT_SCHEDULES_ALL PS, JL_BR_AR_COLLECTION_DOCS_ALL DC,

139: CSC.GL_DATE,
140: CeBankAccount.bank_account_id,
141: DC.org_id,
142: PS.CUSTOMER_ID
143: from AR_PAYMENT_SCHEDULES_ALL PS, JL_BR_AR_COLLECTION_DOCS_ALL DC,
144: JL_BR_AR_BORDEROS B,
145: AR_RECEIPT_METHOD_ACCOUNTS_ALL RMA,
146: JL_BR_AR_SELECT_ACCOUNTS_ALL CSC,
147: JL_BR_AR_REC_MET_ACCTS_EXT_ALL JLBRRMA,

Line 352: update JL_BR_AR_COLLECTION_DOCS_ALL

348: null;
349: end;
350:
351: /* Update status to FORMATTED and update bank accounts */
352: update JL_BR_AR_COLLECTION_DOCS_ALL
353: set DOCUMENT_STATUS = 'FORMATTED',
354: CASH_CCID = cursor_ps.CASH_CCID,
355: BANK_CHARGES_CCID = cursor_ps.BANK_CHARGES_CCID,
356: COLL_ENDORSEMENTS_CCID = cursor_ps.COLL_ENDORSEMENT_CCID,

Line 549: update JL_BR_AR_COLLECTION_DOCS_ALL

545: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'BANK';
546: arp_ps_pkg.update_p(l_ps_rec, CURSOR_PS.PAYMENT_SCHEDULE_ID);
547:
548: /* Update status to FORMATTED and update bank accounts */
549: update JL_BR_AR_COLLECTION_DOCS_ALL
550: set DOCUMENT_STATUS = 'FORMATTED',
551: CASH_CCID = cursor_ps.CASH_CCID,
552: BANK_CHARGES_CCID = cursor_ps.BANK_CHARGES_CCID,
553: COLL_ENDORSEMENTS_CCID = cursor_ps.DISC_ENDORSEMENT_CCID,

Line 709: from JL_BR_AR_COLLECTION_DOCS

705: if TMP.STD_OCCURRENCE_CODE = 'PROTEST' then
706: /* update AR_PAYMENT_SCHEDULES
707: set GLOBAL_ATTRIBUTE9 = 'REGISTRY'
708: where PAYMENT_SCHEDULE_ID = (select PAYMENT_SCHEDULE_ID
709: from JL_BR_AR_COLLECTION_DOCS
710: where DOCUMENT_ID = TMP.DOCUMENT_ID);
711: */
712:
713: /* Replace Update by AR's Table Handlers. Bug # 2249731 */

Line 716: FROM jl_br_ar_collection_docs

712:
713: /* Replace Update by AR's Table Handlers. Bug # 2249731 */
714: SELECT payment_schedule_id
715: INTO l_ps_id
716: FROM jl_br_ar_collection_docs
717: WHERE document_id = TMP.DOCUMENT_ID;
718:
719: arp_ps_pkg.fetch_p(l_ps_id, l_ps_rec);
720: arp_ps_pkg.lock_p(l_ps_id);

Line 731: from JL_BR_AR_COLLECTION_DOCS

727: SET selected_for_receipt_batch_id = NULL,
728: global_attribute9 = 'MANUAL_RECEIPT',
729: global_attribute11 = 'N'
730: where PAYMENT_SCHEDULE_ID = (select PAYMENT_SCHEDULE_ID
731: from JL_BR_AR_COLLECTION_DOCS
732: where DOCUMENT_ID = TMP.DOCUMENT_ID);
733: */
734:
735: /* Replace Update by AR's Table Handlers. Bug # 2249731 */

Line 739: FROM jl_br_ar_collection_docs

735: /* Replace Update by AR's Table Handlers. Bug # 2249731 */
736:
737: SELECT payment_schedule_id
738: INTO l_ps_id
739: FROM jl_br_ar_collection_docs
740: WHERE document_id = TMP.DOCUMENT_ID;
741:
742: arp_ps_pkg.fetch_p(l_ps_id, l_ps_rec);
743: arp_ps_pkg.lock_p(l_ps_id);