DBA Data[Home] [Help]

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 334: /* update AR_PAYMENT_SCHEDULES

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

Line 514: AR_PAYMENT_SCHEDULES PS

510: CURSOR_PS.FACTORING_AMOUNT,
511: CURSOR_PS.FACTORING_AMOUNT,
512: CURSOR_PS.ORG_ID
513: from RA_CUSTOMER_TRX CT, RA_TERMS_LINES_DISCOUNTS T,
514: AR_PAYMENT_SCHEDULES PS
515: where CT.CUSTOMER_TRX_ID = PS.CUSTOMER_TRX_ID
516: and T.TERM_ID(+) = PS.TERM_ID
517: and T.SEQUENCE_NUM(+) = PS.TERMS_SEQUENCE_NUMBER
518: and PS.PAYMENT_SCHEDULE_ID = CURSOR_PS.PAYMENT_SCHEDULE_ID;

Line 686: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;

682: and BO.BANK_OCCURRENCE_CODE = OD.BANK_OCCURRENCE_CODE
683: --and BO.BANK_NUMBER = OD.BANK_NUMBER;
684: and BO.BANK_PARTY_ID = OD.BANK_PARTY_ID;
685:
686: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
687: l_ps_rec ar_payment_schedules%ROWTYPE;
688: begin
689: P_PROC_STATUS := 0;
690: OPEN check1;

Line 687: l_ps_rec ar_payment_schedules%ROWTYPE;

683: --and BO.BANK_NUMBER = OD.BANK_NUMBER;
684: and BO.BANK_PARTY_ID = OD.BANK_PARTY_ID;
685:
686: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
687: l_ps_rec ar_payment_schedules%ROWTYPE;
688: begin
689: P_PROC_STATUS := 0;
690: OPEN check1;
691: LOOP

Line 706: /* update AR_PAYMENT_SCHEDULES

702: update JL_BR_AR_OCCURRENCE_DOCS_ALL
703: set OCCURRENCE_STATUS = 'CONFIRMED'
704: where OCCURRENCE_ID = TMP.OCCURRENCE_ID;
705: if TMP.STD_OCCURRENCE_CODE = 'PROTEST' then
706: /* update AR_PAYMENT_SCHEDULES
707: set GLOBAL_ATTRIBUTE9 = 'REGISTRY'
708: where PAYMENT_SCHEDULE_ID = (select PAYMENT_SCHEDULE_ID
709: from JL_BR_AR_COLLECTION_DOCS
710: where DOCUMENT_ID = TMP.DOCUMENT_ID);

Line 726: /* UPDATE ar_payment_schedules

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