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 635: from jl_br_ar_borderos_all

631: fnd_global.user_id,
632: bordero_id,
633: output_program_id,
634: org_id
635: from jl_br_ar_borderos_all
636: where bordero_id = P_BORDERO_ID;
637: EXCEPTION
638: WHEN OTHERS THEN
639: null;

Line 665: FROM jl_br_ar_borderos_all

661: var_selection_control_chk NUMBER;
662:
663: CURSOR check1 IS
664: SELECT bordero_status, selection_control_id
665: FROM jl_br_ar_borderos_all
666: WHERE bordero_id = P_BORDERO_ID
667: AND bordero_status in ('SELECTED', 'FORMATTED')
668: FOR UPDATE NOWAIT;
669:

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

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
768: set BORDERO_STATUS = 'FORMATTED',
769: REMITTANCE_DATE = SYSDATE
770: where BORDERO_ID = P_BORDERO_ID;
771: