APPS.JL_BR_AR_REMIT_COLL_OCCUR dependencies on JL_BR_AR_BORDEROS

Line 28: FROM jl_br_ar_borderos

24: l_org_id NUMBER;
25:
26: CURSOR check1 IS
27: SELECT bordero_status, selection_control_id,bordero_type
28: FROM jl_br_ar_borderos
29: WHERE bordero_id = P_BORDERO_ID
30: AND bordero_status in ('SELECTED', 'FORMATTED')
31: FOR UPDATE NOWAIT;
32:

Line 76: JL_BR_AR_BORDEROS B,

72: JLBRRMA.ABATEMENT_WRITEOFF_RECTRX_ID,
73: JLBRRMA.ABATEMENT_REVENUE_RECTRX_ID,
74: CSC.GL_DATE
75: from AR_PAYMENT_SCHEDULES_ALL PS, JL_BR_AR_COLLECTION_DOCS_ALL DC,
76: JL_BR_AR_BORDEROS B,
77: AR_RECEIPT_METHOD_ACCOUNTS_ALL RMA,
78: JL_BR_AR_SELECT_ACCOUNTS_ALL CSC,
79: JL_BR_AR_REC_MET_ACCTS_EXT_ALL JLBRRMA,
80: AP_BANK_ACCOUNTS_ALL apba,

Line 144: JL_BR_AR_BORDEROS B,

140: CeBankAccount.bank_account_id,
141: DC.org_id,
142: PS.CUSTOMER_ID
143: from AR_PAYMENT_SCHEDULES_ALL PS, JL_BR_AR_COLLECTION_DOCS_ALL DC,
144: JL_BR_AR_BORDEROS B,
145: AR_RECEIPT_METHOD_ACCOUNTS_ALL RMA,
146: JL_BR_AR_SELECT_ACCOUNTS_ALL CSC,
147: JL_BR_AR_REC_MET_ACCTS_EXT_ALL JLBRRMA,
148: JL_BR_AR_BANK_OCCURRENCES jlbo,

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 583: JL_BR_AR_BORDEROS B

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:
587: if PL_CS_SELECTION_STATUS = 'SELECTED'

Line 609: update JL_BR_AR_BORDEROS

605: where SELECT_ACCOUNT_ID = PL_SELECT_ACCOUNT_ID;
606: end if;
607:
608: /* Update status to FORMATTED */
609: update JL_BR_AR_BORDEROS
610: set BORDERO_STATUS = 'FORMATTED',
611: REMITTANCE_DATE = SYSDATE
612: where BORDERO_ID = P_BORDERO_ID;
613:

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 681: JL_BR_AR_BORDEROS B,

677: was not formated */
678: cursor OC is
679: select OD.OCCURRENCE_ID, BO.STD_OCCURRENCE_CODE, OD.DOCUMENT_ID
680: from JL_BR_AR_OCCURRENCE_DOCS_ALL OD,
681: JL_BR_AR_BORDEROS B,
682: JL_BR_AR_BANK_OCCURRENCES BO
683: where OD.OCCURRENCE_STATUS = 'SELECTED'
684: and B.BORDERO_STATUS = 'SELECTED'
685: and B.BORDERO_ID = OD.BORDERO_ID

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:

Line 814: from jl_br_ar_borderos

810: fnd_global.user_id,
811: bordero_id,
812: output_program_id,
813: mo_global.get_current_org_id
814: from jl_br_ar_borderos
815: where bordero_id = P_BORDERO_ID;
816:
817:
818: P_PROC_STATUS := 1;