DBA Data[Home] [Help]

APPS.JAI_ETCS_PKG dependencies on JAI_AP_RGM_PAYMENTS

Line 2291: from jai_ap_rgm_payments

2287: source_ref_document_id = cp_source_doc_id and
2288: jra.source_document_date between p_from_date and p_to_date
2289: and settlement_id
2290: IN ( select settlement_id
2291: from jai_ap_rgm_payments
2292: where check_id = cp_check_id
2293: )
2294: ) ;
2295:

Line 2328: from jai_ap_rgm_payments

2324: source_ref_document_id = cp_source_document_ref_id and
2325: jra.source_document_date between p_from_date and p_to_date
2326: and settlement_id
2327: IN ( select settlement_id
2328: from jai_ap_rgm_payments
2329: where check_id = cp_check_id
2330: ) ;
2331:
2332:

Line 2435: jai_ap_rgm_payments jrp,

2431: fnd_global.user_id ,
2432: sysdate ,
2433: fnd_global.login_id
2434: from
2435: jai_ap_rgm_payments jrp,
2436: jai_rgm_refs_all jra,
2437: jai_rgm_taxes jrt,
2438: jai_rgm_certificates jrc
2439: where

Line 2885: from jai_ap_rgm_payments

2881:
2882: cursor c_book_entry(cp_check_id number)
2883: is
2884: select nvl(book_entry_deposited,'N')
2885: from jai_ap_rgm_payments
2886: where check_id = cp_check_id ;
2887:
2888: v_book_entry VARCHAR2(1) ;
2889: