APPS.ARI_SELF_REG_CONFIG dependencies on AR_PAYMENT_SCHEDULES

Line 156: FROM ar_payment_schedules

152: BEGIN
153: --Select an open invoice
154: SELECT trx_number
155: INTO l_trx_number
156: FROM ar_payment_schedules
157: WHERE customer_id = p_customer_id
158: AND customer_site_use_id = nvl(p_customer_site_use_id,customer_site_use_id)
159: AND status like 'OP'
160: AND amount_due_remaining > 0

Line 173: FROM ar_payment_schedules

169: BEGIN
170: --Set the expected answer
171: SELECT to_char(amount_due_remaining)
172: INTO x_verify_access(i).expected_answer
173: FROM ar_payment_schedules
174: WHERE customer_id = p_customer_id
175: AND customer_site_use_id = nvl(p_customer_site_use_id,customer_site_use_id)
176: AND status like 'OP'
177: AND amount_due_remaining > 0

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

381: INTO l_customer_id
382: FROM hz_cust_accounts
383: where account_number = p_search_number;
384:
385: --If user searches by transactions, get customer id from ar_payment_schedules
386: ELSIF p_search_type = 'INVOICES' OR
387: p_search_type = 'PAYMENTS' OR
388: p_search_type = 'DEBIT_MEMOS' OR
389: p_search_type = 'CREDIT_MEMOS' OR

Line 399: FROM ar_payment_schedules

395: * the source. So added 'distinct' in the below query to select unique customer_id.
396: */
397: SELECT DISTINCT customer_id
398: INTO l_customer_id
399: FROM ar_payment_schedules
400: WHERE trx_number = p_search_number
401: AND class = (CASE p_search_type
402: WHEN 'INVOICES' THEN 'INV'
403: WHEN 'PAYMENTS' THEN 'PMT'

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

564: where account_number = p_search_number;
565:
566: l_account_number := p_search_number;
567:
568: --If user searches by transactions, get customer id from ar_payment_schedules
569: ELSIF p_search_type = 'INVOICES' OR
570: p_search_type = 'PAYMENTS' OR
571: p_search_type = 'DEBIT_MEMOS' OR
572: p_search_type = 'CREDIT_MEMOS' OR

Line 582: FROM ar_payment_schedules

578: * the source. So added 'distinct' in the below query to select unique customer_id.
579: */
580: SELECT DISTINCT customer_id
581: INTO l_customer_id
582: FROM ar_payment_schedules
583: WHERE trx_number = p_search_number
584: AND class = (CASE p_search_type
585: WHEN 'INVOICES' THEN 'INV'
586: WHEN 'PAYMENTS' THEN 'PMT'