APPS.JL_BR_AR_REMIT_COLL_OCCUR dependencies on JL_BR_AR_COLLECTION_DOCS_ALL

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,