APPS.JAI_ETCS_PKG dependencies on JAI_RGM_REFS_ALL

Line 1854: from jai_rgm_refs_all jra

1850: from jai_rgm_taxes
1851: where tax_type = cp_tax_type
1852: and trx_ref_id in
1853: ( select trx_ref_id
1854: from jai_rgm_refs_all jra
1855: where
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

Line 1891: from jai_rgm_refs_all jra

1887: from jai_ar_etcs_t for update ;
1888:
1889: cursor c_line_amt(cp_source_document_ref_id number, cp_check_id in number) is
1890: select nvl(sum(line_amt),0)
1891: from jai_rgm_refs_all jra
1892: where
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

Line 1925: from jai_rgm_refs_all

1921:
1922: Cursor c_source_ref_type(cp_source_ref_id in number)
1923: is
1924: select source_document_type
1925: from jai_rgm_refs_all
1926: where source_document_id = cp_source_ref_id
1927: and source_document_type IN (jai_constants.ar_cash_tax_confirmed , jai_constants.trx_type_inv_comp)
1928: and rownum = 1 ;
1929:

Line 1956: lv_source_ref_type jai_rgm_refs_all.source_document_type%TYPE ;

1952:
1953: v_bank_account_id NUMBER(15);
1954: v_bank_branch_code ce_bank_branches_v.BRANCH_NUMBER%TYPE;
1955:
1956: lv_source_ref_type jai_rgm_refs_all.source_document_type%TYPE ;
1957: lv_doc_date date ;
1958:
1959: BEGIN
1960:

Line 2005: jai_rgm_refs_all jra,

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
2009: jrp.settlement_id = jra.settlement_id and