APPS.AR_GET_CUSTOMER_BALANCE_PKG dependencies on AR_PAYMENT_SCHEDULES

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

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

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

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

Line 116: p_site_use_id ar_payment_schedules.customer_site_use_id%TYPE) IS

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

Line 118: FROM ar_payment_schedules ps

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

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

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

Line 125: p_site_use_id ar_payment_schedules.customer_site_use_id%TYPE,

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

Line 126: p_currency ar_payment_schedules.invoice_currency_code%TYPE,

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

Line 127: p_as_of_date ar_payment_schedules.trx_date%TYPE ) is

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

Line 134: FROM ar_payment_schedules ps

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