APPS.ARI_SELF_REG_CONFIG dependencies on AR_PAYMENT_SCHEDULES

Line 93: FROM ar_payment_schedules

89: BEGIN
90: --Select an open invoice
91: SELECT trx_number
92: INTO l_trx_number
93: FROM ar_payment_schedules
94: WHERE customer_id = p_customer_id
95: AND customer_site_use_id = nvl(p_customer_site_use_id,customer_site_use_id)
96: AND status like 'OP'
97: AND invoice_currency_code = 'USD'

Line 111: FROM ar_payment_schedules

107: BEGIN
108: --Set the expected answer
109: SELECT to_char(amount_due_remaining)
110: INTO x_verify_access(1).expected_answer
111: FROM ar_payment_schedules
112: WHERE customer_id = p_customer_id
113: AND customer_site_use_id = nvl(p_customer_site_use_id,customer_site_use_id)
114: AND status like 'OP'
115: AND invoice_currency_code = 'USD'

Line 292: --If user searches by transactions, get customer id from ar_payment_schedules

288: INTO l_customer_id
289: FROM hz_cust_accounts
290: where account_number = p_search_number;
291:
292: --If user searches by transactions, get customer id from ar_payment_schedules
293: ELSIF p_search_type = 'INVOICES' OR
294: p_search_type = 'PAYMENTS' OR
295: p_search_type = 'DEBIT_MEMOS' OR
296: p_search_type = 'CREDIT_MEMOS' OR

Line 306: FROM ar_payment_schedules

302: * the source. So added 'distinct' in the below query to select unique customer_id.
303: */
304: SELECT DISTINCT customer_id
305: INTO l_customer_id
306: FROM ar_payment_schedules
307: WHERE trx_number = p_search_number
308: AND class = (CASE p_search_type
309: WHEN 'INVOICES' THEN 'INV'
310: WHEN 'PAYMENTS' THEN 'PMT'