APPS.JL_BR_AR_REMIT_COLL_OCCUR dependencies on JL_BR_AR_BORDEROS_ALL

Line 177: select org_id into l_org_id from jl_br_ar_borderos_all

173: l_ps_rec ar_payment_schedules%rowtype;
174:
175: begin
176: --mo_global.set_policy_context('S',3812);
177: select org_id into l_org_id from jl_br_ar_borderos_all
178: where bordero_id = p_bordero_id;
179: mo_global.set_policy_context('S',l_org_id);
180: P_PROC_STATUS := 0;
181: SELECT g.set_of_books_id, g.currency_code

Line 630: from jl_br_ar_borderos_all

626: fnd_global.user_id,
627: bordero_id,
628: output_program_id,
629: org_id
630: from jl_br_ar_borderos_all
631: where bordero_id = P_BORDERO_ID;
632: EXCEPTION
633: WHEN OTHERS THEN
634: null;

Line 660: FROM jl_br_ar_borderos_all

656: var_selection_control_chk NUMBER;
657:
658: CURSOR check1 IS
659: SELECT bordero_status, selection_control_id
660: FROM jl_br_ar_borderos_all
661: WHERE bordero_id = P_BORDERO_ID
662: AND bordero_status in ('SELECTED', 'FORMATTED')
663: FOR UPDATE NOWAIT;
664:

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 761: update JL_BR_AR_BORDEROS_ALL

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
762: set BORDERO_STATUS = 'FORMATTED',
763: REMITTANCE_DATE = SYSDATE
764: where BORDERO_ID = P_BORDERO_ID;
765: