DBA Data[Home] [Help]

APPS.JAI_ETCS_PKG dependencies on JAI_AP_RGM_PAYMENTS

Line 1860: from jai_ap_rgm_payments

1856: source_ref_document_id = cp_source_doc_id and
1857: jra.source_document_date between p_from_date and p_to_date
1858: and settlement_id
1859: IN ( select settlement_id
1860: from jai_ap_rgm_payments
1861: where check_id = cp_check_id
1862: )
1863: ) ;
1864:

Line 1897: from jai_ap_rgm_payments

1893: source_ref_document_id = cp_source_document_ref_id and
1894: jra.source_document_date between p_from_date and p_to_date
1895: and settlement_id
1896: IN ( select settlement_id
1897: from jai_ap_rgm_payments
1898: where check_id = cp_check_id
1899: ) ;
1900:
1901:

Line 2004: jai_ap_rgm_payments jrp,

2000: fnd_global.user_id ,
2001: sysdate ,
2002: fnd_global.login_id
2003: from
2004: jai_ap_rgm_payments jrp,
2005: jai_rgm_refs_all jra,
2006: jai_rgm_taxes jrt,
2007: jai_rgm_certificates jrc
2008: where

Line 2383: from jai_ap_rgm_payments

2379:
2380: cursor c_book_entry(cp_check_id number)
2381: is
2382: select nvl(book_entry_deposited,'N')
2383: from jai_ap_rgm_payments
2384: where check_id = cp_check_id ;
2385:
2386: v_book_entry VARCHAR2(1) ;
2387: