[Home] [Help]
248: SELECT distinct aba.global_attribute7
249: INTO X_dual_num
250: FROM ap_bank_accounts_all aba,
251: jl_br_ar_collection_docs cd,
252: ar_payment_schedules_all arps
253: WHERE cd.document_id = X_company_use
254: AND aba.bank_account_id = cd.bank_account_id
255: AND arps.payment_schedule_id = cd.payment_schedule_id
256: -- bug 1892303
262: INTO X_dual_num
263: FROM ce_bank_accounts acct,
264: ce_bank_acct_uses_all acctUse,
265: jl_br_ar_collection_docs cd,
266: ar_payment_schedules_all arps
267: WHERE cd.document_id = X_company_use
268: AND acctUse.bank_acct_use_id = cd.bank_acct_use_id
269: AND acct.bank_account_id = acctUse.bank_account_id
270: AND arps.payment_schedule_id = cd.payment_schedule_id
340:
341: BEGIN
342: SELECT payment_schedule_id
343: INTO X_payment_schedule_id
344: FROM ar_payment_schedules
345: WHERE payment_schedule_id = X_payment_schedule_id;
346:
347: EXCEPTION
348: WHEN NO_DATA_FOUND THEN
357:
358: BEGIN
359: SELECT payment_schedule_id
360: INTO X_payment_schedule_id
361: FROM ar_payment_schedules
362: WHERE trx_number|| '-' ||to_char(terms_sequence_number)=X_your_number;
363:
364: EXCEPTION
365: WHEN NO_DATA_FOUND THEN
520: INTO X_cgc
521: FROM jl_br_company_infos inf,
522: hz_cust_acct_sites_all adr,
523: ra_customer_trx_all trx,
524: ar_payment_schedules pay
525: WHERE pay.payment_schedule_id = X_payment_schedule_id
526: AND trx.customer_trx_id = pay.customer_trx_id
527: AND adr.cust_acct_site_id = trx.remit_to_address_id
528: AND inf.accounting_balancing_segment = adr.global_attribute1
675: ra_customer_trx trx
676: WHERE trx.bill_to_customer_id = cst.cust_account_id
677: AND cst.party_id = pty.party_id
678: AND trx.customer_trx_id = (SELECT customer_trx_id
679: FROM ar_payment_schedules
680: WHERE payment_schedule_id =
681: X_payment_schedule_id);
682: EXCEPTION
683: WHEN NO_DATA_FOUND THEN