[Home] [Help]
150: SELECT distinct aba.global_attribute7
151: INTO X_dual_num
152: FROM ap_bank_accounts_all aba,
153: jl_br_ar_collection_docs cd,
154: ar_payment_schedules_all arps
155: WHERE cd.document_id = X_company_use
156: AND aba.bank_account_id = cd.bank_account_id
157: AND arps.payment_schedule_id = cd.payment_schedule_id
158: -- bug 1892303
164: INTO X_dual_num
165: FROM ce_bank_accounts acct,
166: ce_bank_acct_uses_all acctUse,
167: jl_br_ar_collection_docs cd,
168: ar_payment_schedules_all arps
169: WHERE cd.document_id = X_company_use
170: AND acctUse.bank_acct_use_id = cd.bank_acct_use_id
171: AND acct.bank_account_id = acctUse.bank_account_id
172: AND arps.payment_schedule_id = cd.payment_schedule_id
232:
233: BEGIN
234: SELECT payment_schedule_id
235: INTO X_payment_schedule_id
236: FROM ar_payment_schedules
237: WHERE payment_schedule_id = X_payment_schedule_id;
238:
239: EXCEPTION
240: WHEN NO_DATA_FOUND THEN
249:
250: BEGIN
251: SELECT payment_schedule_id
252: INTO X_payment_schedule_id
253: FROM ar_payment_schedules
254: WHERE trx_number|| '-' ||to_char(terms_sequence_number)=X_your_number;
255:
256: EXCEPTION
257: WHEN NO_DATA_FOUND THEN
372: INTO X_cgc
373: FROM jl_br_company_infos inf,
374: hz_cust_acct_sites_all adr,
375: ra_customer_trx_all trx,
376: ar_payment_schedules pay
377: WHERE pay.payment_schedule_id = X_payment_schedule_id
378: AND trx.customer_trx_id = pay.customer_trx_id
379: AND adr.cust_acct_site_id = trx.remit_to_address_id
380: AND inf.accounting_balancing_segment = adr.global_attribute1
525: ra_customer_trx trx
526: WHERE trx.bill_to_customer_id = cst.cust_account_id
527: AND cst.party_id = pty.party_id
528: AND trx.customer_trx_id = (SELECT customer_trx_id
529: FROM ar_payment_schedules
530: WHERE payment_schedule_id =
531: X_payment_schedule_id);
532: EXCEPTION
533: WHEN NO_DATA_FOUND THEN