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 354: update JL_BR_AR_COLLECTION_DOCS_ALL

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

Line 554: update JL_BR_AR_COLLECTION_DOCS_ALL

550: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'BANK';
551: arp_ps_pkg.update_p(l_ps_rec, CURSOR_PS.PAYMENT_SCHEDULE_ID);
552:
553: /* Update status to FORMATTED and update bank accounts */
554: update JL_BR_AR_COLLECTION_DOCS_ALL
555: set DOCUMENT_STATUS = 'FORMATTED',
556: CASH_CCID = cursor_ps.CASH_CCID,
557: BANK_CHARGES_CCID = cursor_ps.BANK_CHARGES_CCID,
558: COLL_ENDORSEMENTS_CCID = cursor_ps.DISC_ENDORSEMENT_CCID,

Line 714: from JL_BR_AR_COLLECTION_DOCS

710: if TMP.STD_OCCURRENCE_CODE = 'PROTEST' then
711: /* update AR_PAYMENT_SCHEDULES
712: set GLOBAL_ATTRIBUTE9 = 'REGISTRY'
713: where PAYMENT_SCHEDULE_ID = (select PAYMENT_SCHEDULE_ID
714: from JL_BR_AR_COLLECTION_DOCS
715: where DOCUMENT_ID = TMP.DOCUMENT_ID);
716: */
717:
718: /* Replace Update by AR's Table Handlers. Bug # 2249731 */

Line 721: FROM jl_br_ar_collection_docs

717:
718: /* Replace Update by AR's Table Handlers. Bug # 2249731 */
719: SELECT payment_schedule_id
720: INTO l_ps_id
721: FROM jl_br_ar_collection_docs
722: WHERE document_id = TMP.DOCUMENT_ID;
723:
724: arp_ps_pkg.fetch_p(l_ps_id, l_ps_rec);
725: arp_ps_pkg.lock_p(l_ps_id);

Line 736: from JL_BR_AR_COLLECTION_DOCS

732: SET selected_for_receipt_batch_id = NULL,
733: global_attribute9 = 'MANUAL_RECEIPT',
734: global_attribute11 = 'N'
735: where PAYMENT_SCHEDULE_ID = (select PAYMENT_SCHEDULE_ID
736: from JL_BR_AR_COLLECTION_DOCS
737: where DOCUMENT_ID = TMP.DOCUMENT_ID);
738: */
739:
740: /* Replace Update by AR's Table Handlers. Bug # 2249731 */

Line 744: FROM jl_br_ar_collection_docs

740: /* Replace Update by AR's Table Handlers. Bug # 2249731 */
741:
742: SELECT payment_schedule_id
743: INTO l_ps_id
744: FROM jl_br_ar_collection_docs
745: WHERE document_id = TMP.DOCUMENT_ID;
746:
747: arp_ps_pkg.fetch_p(l_ps_id, l_ps_rec);
748: arp_ps_pkg.lock_p(l_ps_id);