DBA Data[Home] [Help]

APPS.JAI_AP_TCS_PROCESSING_PKG dependencies on JAI_RGM_SETTLEMENTS

Line 86: JAI_RGM_SETTLEMENTS jrs

82: jrr.party_site_id,
83: jrs.tax_authority_id,
84: jrs.tax_authority_site_id
85: FROM JAI_RGM_REFS_ALL jrr,
86: JAI_RGM_SETTLEMENTS jrs
87: WHERE jrr.settlement_id = jrs.settlement_id
88: AND jrr.source_document_date BETWEEN pd_rgm_from_date and pd_rgm_to_date
89: AND jrr.certificate_id IS NULL
90: AND jrs.tax_authority_id = pn_tax_authority_id

Line 194: jai_rgm_settlements jrs

190: , last_update_date = sysdate
191: , last_update_login = ln_last_update_login
192: where trx_ref_id in ( SELECT jrr.trx_ref_id
193: FROM jai_rgm_refs_all jrr,
194: jai_rgm_settlements jrs
195: WHERE jrr.settlement_id = jrs.settlement_id
196: AND jrr.source_document_date BETWEEN ld_from_date and ld_to_date
197: AND jrr.certificate_id IS NULL
198: AND jrs.tax_authority_id = cur_rec.tax_authority_id