APPS.JL_BR_AR_REMIT_COLL_OCCUR dependencies on AR_PAYMENT_SCHEDULES

Line 75: from AR_PAYMENT_SCHEDULES_ALL PS, JL_BR_AR_COLLECTION_DOCS_ALL DC,

71: JLBRRMA.INTEREST_REVENUE_RECTRX_ID,
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,

Line 143: from AR_PAYMENT_SCHEDULES_ALL PS, JL_BR_AR_COLLECTION_DOCS_ALL DC,

139: CSC.GL_DATE,
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,

Line 173: l_ps_rec ar_payment_schedules%rowtype;

169: And jlbo.BANK_OCCURRENCE_TYPE = 'REMITTANCE_OCCURRENCE';
170:
171:
172: CURSOR_PS PS%rowtype;
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

Line 303: AR_PAYMENT_SCHEDULES_ALL PS

299: CURSOR_PS.BANK_CHARGE_AMOUNT,
300: CURSOR_PS.BANK_CHARGE_AMOUNT,
301: CURSOR_PS.org_id
302: from RA_CUSTOMER_TRX CT, RA_TERMS_LINES_DISCOUNTS T,
303: AR_PAYMENT_SCHEDULES_ALL PS
304: where CT.CUSTOMER_TRX_ID = PS.CUSTOMER_TRX_ID
305: and T.TERM_ID(+) = PS.TERM_ID
306: and T.SEQUENCE_NUM(+) = PS.TERMS_SEQUENCE_NUMBER
307: and PS.PAYMENT_SCHEDULE_ID = CURSOR_PS.PAYMENT_SCHEDULE_ID;

Line 335: /* update AR_PAYMENT_SCHEDULES

331: WHERE occurrence_id = l_occurrence_id;
332: -- End SLA Uptake - Bug#4301543
333:
334: /* Update collection flag to WRITE_OFF */
335: /* update AR_PAYMENT_SCHEDULES
336: set GLOBAL_ATTRIBUTE11 = 'Y',
337: GLOBAL_ATTRIBUTE9 = 'BANK'
338: where PAYMENT_SCHEDULE_ID = CURSOR_PS.PAYMENT_SCHEDULE_ID;
339: */

Line 518: AR_PAYMENT_SCHEDULES PS

514: CURSOR_PS.FACTORING_AMOUNT,
515: CURSOR_PS.FACTORING_AMOUNT,
516: CURSOR_PS.ORG_ID
517: from RA_CUSTOMER_TRX CT, RA_TERMS_LINES_DISCOUNTS T,
518: AR_PAYMENT_SCHEDULES PS
519: where CT.CUSTOMER_TRX_ID = PS.CUSTOMER_TRX_ID
520: and T.TERM_ID(+) = PS.TERM_ID
521: and T.SEQUENCE_NUM(+) = PS.TERMS_SEQUENCE_NUMBER
522: and PS.PAYMENT_SCHEDULE_ID = CURSOR_PS.PAYMENT_SCHEDULE_ID;

Line 691: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;

687: and BO.BANK_OCCURRENCE_CODE = OD.BANK_OCCURRENCE_CODE
688: --and BO.BANK_NUMBER = OD.BANK_NUMBER;
689: and BO.BANK_PARTY_ID = OD.BANK_PARTY_ID;
690:
691: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
692: l_ps_rec ar_payment_schedules%ROWTYPE;
693: begin
694: P_PROC_STATUS := 0;
695: OPEN check1;

Line 692: l_ps_rec ar_payment_schedules%ROWTYPE;

688: --and BO.BANK_NUMBER = OD.BANK_NUMBER;
689: and BO.BANK_PARTY_ID = OD.BANK_PARTY_ID;
690:
691: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
692: l_ps_rec ar_payment_schedules%ROWTYPE;
693: begin
694: P_PROC_STATUS := 0;
695: OPEN check1;
696: LOOP

Line 711: /* update AR_PAYMENT_SCHEDULES

707: update JL_BR_AR_OCCURRENCE_DOCS_ALL
708: set OCCURRENCE_STATUS = 'CONFIRMED'
709: where OCCURRENCE_ID = TMP.OCCURRENCE_ID;
710: if TMP.STD_OCCURRENCE_CODE = 'PROTEST' then
711: /* update AR_PAYMENT_SCHEDULES
712: set GLOBAL_ATTRIBUTE9 = 'REGISTRY'
713: where PAYMENT_SCHEDULE_ID = (select PAYMENT_SCHEDULE_ID
714: from JL_BR_AR_COLLECTION_DOCS
715: where DOCUMENT_ID = TMP.DOCUMENT_ID);

Line 731: /* UPDATE ar_payment_schedules

727: arp_ps_pkg.update_p(l_ps_rec, l_ps_id);
728:
729: /* Following elsif added for Bug 865082 */
730: elsif TMP.STD_OCCURRENCE_CODE = 'WRITE_OFF_REQUISITION' then
731: /* UPDATE ar_payment_schedules
732: SET selected_for_receipt_batch_id = NULL,
733: global_attribute9 = 'MANUAL_RECEIPT',
734: global_attribute11 = 'N'
735: where PAYMENT_SCHEDULE_ID = (select PAYMENT_SCHEDULE_ID