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 594: update JL_BR_AR_SELECT_ACCOUNTS

590: update JL_BR_AR_SELECT_CONTROLS
591: set SELECTION_STATUS = 'FORMATTED',
592: REMITTANCE_DATE = SYSDATE
593: where SELECTION_CONTROL_ID = PL_SELECTION_CONTROL_ID;
594: update JL_BR_AR_SELECT_ACCOUNTS
595: set FORMAT_DATE= SYSDATE,
596: REMITTANCE_DATE = SYSDATE
597: where SELECT_ACCOUNT_ID = PL_SELECT_ACCOUNT_ID;
598: else

Line 603: update JL_BR_AR_SELECT_ACCOUNTS

599: /* Update remittance date */
600: update JL_BR_AR_SELECT_CONTROLS
601: set REMITTANCE_DATE = SYSDATE
602: where SELECTION_CONTROL_ID = PL_SELECTION_CONTROL_ID;
603: update JL_BR_AR_SELECT_ACCOUNTS
604: set REMITTANCE_DATE = SYSDATE
605: where SELECT_ACCOUNT_ID = PL_SELECT_ACCOUNT_ID;
606: end if;
607:

Line 780: update JL_BR_AR_SELECT_ACCOUNTS

776: set SELECTION_STATUS = 'FORMATTED',
777: GENERATION_DATE = SYSDATE,
778: REMITTANCE_DATE = SYSDATE
779: where SELECTION_CONTROL_ID = PL_SELECTION_CONTROL_ID;
780: update JL_BR_AR_SELECT_ACCOUNTS
781: set FORMAT_DATE = SYSDATE,
782: REMITTANCE_DATE = SYSDATE
783: where SELECT_ACCOUNT_ID = PL_SELECT_ACCOUNT_ID;
784: else

Line 789: update JL_BR_AR_SELECT_ACCOUNTS

785: /* Update remittance date */
786: update JL_BR_AR_SELECT_CONTROLS_ALL
787: set REMITTANCE_DATE = SYSDATE
788: where SELECTION_CONTROL_ID = PL_SELECTION_CONTROL_ID;
789: update JL_BR_AR_SELECT_ACCOUNTS
790: set REMITTANCE_DATE = SYSDATE
791: where SELECT_ACCOUNT_ID = PL_SELECT_ACCOUNT_ID;
792: end if;
793: