APPS.JL_BR_AR_REMIT_COLL_OCCUR dependencies on JL_BR_AR_SELECT_CONTROLS_ALL

Line 582: from JL_BR_AR_SELECT_CONTROLS_ALL CS,

578: B.SELECT_ACCOUNT_ID
579: into PL_CS_SELECTION_STATUS,
580: PL_SELECTION_CONTROL_ID,
581: PL_SELECT_ACCOUNT_ID
582: from JL_BR_AR_SELECT_CONTROLS_ALL CS,
583: JL_BR_AR_BORDEROS B
584: where CS.SELECTION_CONTROL_ID = B.SELECTION_CONTROL_ID
585: and B.BORDERO_ID = P_BORDERO_ID;
586:

Line 672: FROM jl_br_ar_select_controls_all

668: FOR UPDATE NOWAIT;
669:
670: CURSOR check2 IS
671: SELECT selection_control_id
672: FROM jl_br_ar_select_controls_all
673: WHERE selection_control_id = var_selection_control
674: FOR UPDATE;
675:
676: /* This cursor is used to read documents from Borderos that

Line 763: from JL_BR_AR_BORDEROS_ALL B, JL_BR_AR_SELECT_CONTROLS_ALL CS

759: CS.SELECTION_STATUS
760: into PL_SELECTION_CONTROL_ID,
761: PL_SELECT_ACCOUNT_ID,
762: PL_CS_SELECTION_STATUS
763: from JL_BR_AR_BORDEROS_ALL B, JL_BR_AR_SELECT_CONTROLS_ALL CS
764: where B.BORDERO_ID = P_BORDERO_ID
765: and CS.SELECTION_CONTROL_ID = B.SELECTION_CONTROL_ID;
766: /* Update bordero status to FORMATTED */
767: update JL_BR_AR_BORDEROS_ALL

Line 775: update JL_BR_AR_SELECT_CONTROLS_ALL

771:
772: if PL_CS_SELECTION_STATUS = 'SELECTED'
773: then
774: /* Update selection status to FORMATTED */
775: update JL_BR_AR_SELECT_CONTROLS_ALL
776: set SELECTION_STATUS = 'FORMATTED',
777: GENERATION_DATE = SYSDATE,
778: REMITTANCE_DATE = SYSDATE
779: where SELECTION_CONTROL_ID = PL_SELECTION_CONTROL_ID;

Line 786: update JL_BR_AR_SELECT_CONTROLS_ALL

782: REMITTANCE_DATE = SYSDATE
783: where SELECT_ACCOUNT_ID = PL_SELECT_ACCOUNT_ID;
784: else
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