APPS.JL_BR_AR_REMIT_COLL_OCCUR dependencies on JL_BR_AR_SELECT_CONTROLS

Line 35: FROM jl_br_ar_select_controls

31: FOR UPDATE NOWAIT;
32:
33: CURSOR check2 IS
34: SELECT selection_control_id
35: FROM jl_br_ar_select_controls
36: WHERE selection_control_id = var_selection_control
37: FOR UPDATE;
38:
39: /* Cursor PS is used to read documents from bordero which were not remitted */

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 590: update JL_BR_AR_SELECT_CONTROLS

586:
587: if PL_CS_SELECTION_STATUS = 'SELECTED'
588: then
589: /* Update status to FORMATTED */
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

Line 600: update JL_BR_AR_SELECT_CONTROLS

596: REMITTANCE_DATE = SYSDATE
597: where SELECT_ACCOUNT_ID = PL_SELECT_ACCOUNT_ID;
598: else
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

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