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

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

Line 604: update JL_BR_AR_BORDEROS

600: where SELECT_ACCOUNT_ID = PL_SELECT_ACCOUNT_ID;
601: end if;
602:
603: /* Update status to FORMATTED */
604: update JL_BR_AR_BORDEROS
605: set BORDERO_STATUS = 'FORMATTED',
606: REMITTANCE_DATE = SYSDATE
607: where BORDERO_ID = P_BORDERO_ID;
608:

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

672: was not formated */
673: cursor OC is
674: select OD.OCCURRENCE_ID, BO.STD_OCCURRENCE_CODE, OD.DOCUMENT_ID
675: from JL_BR_AR_OCCURRENCE_DOCS_ALL OD,
676: JL_BR_AR_BORDEROS B,
677: JL_BR_AR_BANK_OCCURRENCES BO
678: where OD.OCCURRENCE_STATUS = 'SELECTED'
679: and B.BORDERO_STATUS = 'SELECTED'
680: and B.BORDERO_ID = OD.BORDERO_ID

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:

Line 808: from jl_br_ar_borderos

804: fnd_global.user_id,
805: bordero_id,
806: output_program_id,
807: mo_global.get_current_org_id
808: from jl_br_ar_borderos
809: where bordero_id = P_BORDERO_ID;
810:
811:
812: P_PROC_STATUS := 1;