APPS.JL_BR_AR_REMIT_COLL_OCCUR dependencies on JL_BR_AR_SELECT_ACCOUNTS

Line 78: JL_BR_AR_SELECT_ACCOUNTS_ALL CSC,

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,
80: AP_BANK_ACCOUNTS_ALL apba,
81: AP_BANK_BRANCHES apbb,
82: JL_BR_AR_BANK_OCCURRENCES jlbo

Line 146: JL_BR_AR_SELECT_ACCOUNTS_ALL CSC,

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,
148: JL_BR_AR_BANK_OCCURRENCES jlbo,
149: CE_BANK_ACCOUNTS CeBankAccount,
150: CE_BANK_ACCT_USES_ALL CeBankAcctUse,

Line 589: update JL_BR_AR_SELECT_ACCOUNTS

585: update JL_BR_AR_SELECT_CONTROLS
586: set SELECTION_STATUS = 'FORMATTED',
587: REMITTANCE_DATE = SYSDATE
588: where SELECTION_CONTROL_ID = PL_SELECTION_CONTROL_ID;
589: update JL_BR_AR_SELECT_ACCOUNTS
590: set FORMAT_DATE= SYSDATE,
591: REMITTANCE_DATE = SYSDATE
592: where SELECT_ACCOUNT_ID = PL_SELECT_ACCOUNT_ID;
593: else

Line 598: update JL_BR_AR_SELECT_ACCOUNTS

594: /* Update remittance date */
595: update JL_BR_AR_SELECT_CONTROLS
596: set REMITTANCE_DATE = SYSDATE
597: where SELECTION_CONTROL_ID = PL_SELECTION_CONTROL_ID;
598: update JL_BR_AR_SELECT_ACCOUNTS
599: set REMITTANCE_DATE = SYSDATE
600: where SELECT_ACCOUNT_ID = PL_SELECT_ACCOUNT_ID;
601: end if;
602:

Line 774: update JL_BR_AR_SELECT_ACCOUNTS

770: set SELECTION_STATUS = 'FORMATTED',
771: GENERATION_DATE = SYSDATE,
772: REMITTANCE_DATE = SYSDATE
773: where SELECTION_CONTROL_ID = PL_SELECTION_CONTROL_ID;
774: update JL_BR_AR_SELECT_ACCOUNTS
775: set FORMAT_DATE = SYSDATE,
776: REMITTANCE_DATE = SYSDATE
777: where SELECT_ACCOUNT_ID = PL_SELECT_ACCOUNT_ID;
778: else

Line 783: update JL_BR_AR_SELECT_ACCOUNTS

779: /* Update remittance date */
780: update JL_BR_AR_SELECT_CONTROLS_ALL
781: set REMITTANCE_DATE = SYSDATE
782: where SELECTION_CONTROL_ID = PL_SELECTION_CONTROL_ID;
783: update JL_BR_AR_SELECT_ACCOUNTS
784: set REMITTANCE_DATE = SYSDATE
785: where SELECT_ACCOUNT_ID = PL_SELECT_ACCOUNT_ID;
786: end if;
787: