APPS.JL_BR_AR_REMIT_COLL_OCCUR dependencies on JL_BR_AR_SELECT_CONTROLS_ALL

Line 577: from JL_BR_AR_SELECT_CONTROLS_ALL CS,

573: B.SELECT_ACCOUNT_ID
574: into PL_CS_SELECTION_STATUS,
575: PL_SELECTION_CONTROL_ID,
576: PL_SELECT_ACCOUNT_ID
577: from JL_BR_AR_SELECT_CONTROLS_ALL CS,
578: JL_BR_AR_BORDEROS B
579: where CS.SELECTION_CONTROL_ID = B.SELECTION_CONTROL_ID
580: and B.BORDERO_ID = P_BORDERO_ID;
581:

Line 667: FROM jl_br_ar_select_controls_all

663: FOR UPDATE NOWAIT;
664:
665: CURSOR check2 IS
666: SELECT selection_control_id
667: FROM jl_br_ar_select_controls_all
668: WHERE selection_control_id = var_selection_control
669: FOR UPDATE;
670:
671: /* This cursor is used to read documents from Borderos that

Line 757: from JL_BR_AR_BORDEROS_ALL B, JL_BR_AR_SELECT_CONTROLS_ALL CS

753: CS.SELECTION_STATUS
754: into PL_SELECTION_CONTROL_ID,
755: PL_SELECT_ACCOUNT_ID,
756: PL_CS_SELECTION_STATUS
757: from JL_BR_AR_BORDEROS_ALL B, JL_BR_AR_SELECT_CONTROLS_ALL CS
758: where B.BORDERO_ID = P_BORDERO_ID
759: and CS.SELECTION_CONTROL_ID = B.SELECTION_CONTROL_ID;
760: /* Update bordero status to FORMATTED */
761: update JL_BR_AR_BORDEROS_ALL

Line 769: update JL_BR_AR_SELECT_CONTROLS_ALL

765:
766: if PL_CS_SELECTION_STATUS = 'SELECTED'
767: then
768: /* Update selection status to FORMATTED */
769: update JL_BR_AR_SELECT_CONTROLS_ALL
770: set SELECTION_STATUS = 'FORMATTED',
771: GENERATION_DATE = SYSDATE,
772: REMITTANCE_DATE = SYSDATE
773: where SELECTION_CONTROL_ID = PL_SELECTION_CONTROL_ID;

Line 780: update JL_BR_AR_SELECT_CONTROLS_ALL

776: REMITTANCE_DATE = SYSDATE
777: where SELECT_ACCOUNT_ID = PL_SELECT_ACCOUNT_ID;
778: else
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