APPS.JL_ZZ_AR_LIBRARY_1_PKG dependencies on AR_PAYMENT_SCHEDULES

Line 4: -- Get customer_trx_id from ar_payment_schedules

1: PACKAGE BODY JL_ZZ_AR_LIBRARY_1_PKG AS
2: /* $Header: jlzzrl1b.pls 120.18 2006/11/21 19:06:06 appradha ship $ */
3:
4: -- Get customer_trx_id from ar_payment_schedules
5: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AR_ENABLE_DEBUG_OUTPUT'), 'N');
6:
7: PROCEDURE get_customer_trx_id (pay_sched_id IN NUMBER,
8: cust_trx_id IN OUT NOCOPY NUMBER,

Line 16: FROM ar_payment_schedules arps, ra_customer_trx ract

12: BEGIN
13: Errcd := 0;
14: SELECT arps.customer_trx_id,ract.trx_date
15: INTO cust_trx_id,trans_date
16: FROM ar_payment_schedules arps, ra_customer_trx ract
17: WHERE arps.payment_schedule_id = pay_sched_id
18: AND ract.customer_trx_id = arps.customer_trx_id
19: AND rownum = row_number;
20:

Line 122: -- Get interest_payment_date from ar_payment_schedules

118: Errcd := SQLCODE;
119: END get_idm_profiles_from_syspa;
120:
121:
122: -- Get interest_payment_date from ar_payment_schedules
123: PROCEDURE get_interest_payment_date (pay_schd_id IN NUMBER,
124: interest_payment_date IN OUT NOCOPY VARCHAR2,
125: row_number IN NUMBER,
126: Errcd IN OUT NOCOPY NUMBER) IS

Line 131: FROM ar_payment_schedules

127: BEGIN
128: Errcd := 0;
129: SELECT MAX (global_attribute7)
130: INTO interest_payment_date
131: FROM ar_payment_schedules
132: WHERE payment_schedule_id = pay_schd_id;
133: EXCEPTION
134: WHEN OTHERS THEN
135: Errcd := SQLCODE;

Line 179: FROM ar_payment_schedules arps,

175: BEGIN
176: Errcd := 0;
177: SELECT loc.city
178: INTO city
179: FROM ar_payment_schedules arps,
180: hz_cust_acct_sites ad,
181: hz_cust_site_uses hzsu,
182: ra_customer_trx ract,
183: -- ra_site_uses rasu,

Line 456: FROM ar_payment_schedules

452: BEGIN
453: Errcd := 0;
454: SELECT global_attribute2
455: INTO bearer_tr_note
456: FROM ar_payment_schedules
457: WHERE payment_schedule_id = pay_sched_id
458: AND rownum = row_number;
459: EXCEPTION
460: WHEN OTHERS THEN

Line 584: FROM ar_payment_schedules

580: BEGIN
581: Errcd := 0;
582: SELECT class
583: INTO p_class
584: FROM ar_payment_schedules
585: WHERE trx_number = p_trx_number;
586: EXCEPTION
587: WHEN OTHERS THEN
588: Errcd := SQLCODE;

Line 916: FROM ar_payment_schedules arps,

912: SELECT loc.city,
913: loc.state --Bug 2319552
914: INTO city,
915: state --Bug 2319552
916: FROM ar_payment_schedules arps,
917: hz_cust_acct_sites ad,
918: hz_cust_site_uses hzsu,
919: ra_customer_trx ract,
920: --ra_site_uses rasu,