APPS.AR_GET_CUSTOMER_BALANCE_PKG dependencies on AR_PAYMENT_SCHEDULES

Line 86: CURSOR siteinfo(p_customer_id ar_payment_schedules.customer_id%TYPE,

82: upper(cust_acct.account_number) >= upper(p_customer_number_low))
83: AND (p_customer_number_high is null or
84: upper(cust_acct.account_number) <= upper(p_customer_number_high));
85:
86: CURSOR siteinfo(p_customer_id ar_payment_schedules.customer_id%TYPE,
87: p_base_language hz_locations.language%TYPE,
88: p_session_language hz_locations.language%TYPE ) IS
89: SELECT site_uses.site_use_id ,
90: acct_site.translated_customer_name,

Line 114: CURSOR curinfo(p_customer_id ar_payment_schedules.customer_id%TYPE,

110: AND site_uses.site_use_code = 'BILL_TO'
111: AND nvl(loc.language,p_session_language)=p_session_language;/*Bug 8486880*/
112:
113: --Selects all the currency for a customer site
114: CURSOR curinfo(p_customer_id ar_payment_schedules.customer_id%TYPE,
115: p_site_use_id ar_payment_schedules.customer_site_use_id%TYPE) IS
116: SELECT distinct(invoice_currency_code) currency_code
117: FROM ar_payment_schedules ps
118: WHERE ps.customer_id=p_customer_id

Line 115: p_site_use_id ar_payment_schedules.customer_site_use_id%TYPE) IS

111: AND nvl(loc.language,p_session_language)=p_session_language;/*Bug 8486880*/
112:
113: --Selects all the currency for a customer site
114: CURSOR curinfo(p_customer_id ar_payment_schedules.customer_id%TYPE,
115: p_site_use_id ar_payment_schedules.customer_site_use_id%TYPE) IS
116: SELECT distinct(invoice_currency_code) currency_code
117: FROM ar_payment_schedules ps
118: WHERE ps.customer_id=p_customer_id
119: AND PS.customer_site_use_id=p_site_use_id

Line 117: FROM ar_payment_schedules ps

113: --Selects all the currency for a customer site
114: CURSOR curinfo(p_customer_id ar_payment_schedules.customer_id%TYPE,
115: p_site_use_id ar_payment_schedules.customer_site_use_id%TYPE) IS
116: SELECT distinct(invoice_currency_code) currency_code
117: FROM ar_payment_schedules ps
118: WHERE ps.customer_id=p_customer_id
119: AND PS.customer_site_use_id=p_site_use_id
120: AND ps.invoice_currency_code=nvl(p_currency,ps.invoice_currency_code);
121:

Line 123: CURSOR tot_inv(p_customer_id ar_payment_schedules.customer_id%TYPE,

119: AND PS.customer_site_use_id=p_site_use_id
120: AND ps.invoice_currency_code=nvl(p_currency,ps.invoice_currency_code);
121:
122: --selects invoices
123: CURSOR tot_inv(p_customer_id ar_payment_schedules.customer_id%TYPE,
124: p_site_use_id ar_payment_schedules.customer_site_use_id%TYPE,
125: p_currency ar_payment_schedules.invoice_currency_code%TYPE,
126: p_as_of_date ar_payment_schedules.trx_date%TYPE ) is
127: SELECT payment_schedule_id ,

Line 124: p_site_use_id ar_payment_schedules.customer_site_use_id%TYPE,

120: AND ps.invoice_currency_code=nvl(p_currency,ps.invoice_currency_code);
121:
122: --selects invoices
123: CURSOR tot_inv(p_customer_id ar_payment_schedules.customer_id%TYPE,
124: p_site_use_id ar_payment_schedules.customer_site_use_id%TYPE,
125: p_currency ar_payment_schedules.invoice_currency_code%TYPE,
126: p_as_of_date ar_payment_schedules.trx_date%TYPE ) is
127: SELECT payment_schedule_id ,
128: class,

Line 125: p_currency ar_payment_schedules.invoice_currency_code%TYPE,

121:
122: --selects invoices
123: CURSOR tot_inv(p_customer_id ar_payment_schedules.customer_id%TYPE,
124: p_site_use_id ar_payment_schedules.customer_site_use_id%TYPE,
125: p_currency ar_payment_schedules.invoice_currency_code%TYPE,
126: p_as_of_date ar_payment_schedules.trx_date%TYPE ) is
127: SELECT payment_schedule_id ,
128: class,
129: trx_number ,

Line 126: p_as_of_date ar_payment_schedules.trx_date%TYPE ) is

122: --selects invoices
123: CURSOR tot_inv(p_customer_id ar_payment_schedules.customer_id%TYPE,
124: p_site_use_id ar_payment_schedules.customer_site_use_id%TYPE,
125: p_currency ar_payment_schedules.invoice_currency_code%TYPE,
126: p_as_of_date ar_payment_schedules.trx_date%TYPE ) is
127: SELECT payment_schedule_id ,
128: class,
129: trx_number ,
130: trx_date ,

Line 133: FROM ar_payment_schedules ps

129: trx_number ,
130: trx_date ,
131: invoice_currency_code,
132: amount_due_original
133: FROM ar_payment_schedules ps
134: WHERE TRUNC(ps.trx_date) <= p_as_of_date
135: AND ps.class not in ( 'PMT' ,decode(p_account_credits, 'Y', 'PMT','CM') )
136: AND ps.invoice_currency_code=p_currency
137: AND ps.customer_id= p_customer_id