APPS.JAI_AP_TCS_PROCESSING_PKG dependencies on JAI_RGM_REFS_ALL

Line 103: FROM JAI_RGM_REFS_ALL jrr,

99: jrr.party_site_id,
100: jrs.tax_authority_id,
101: jrs.tax_authority_site_id,
102: jrr.item_classification
103: FROM JAI_RGM_REFS_ALL jrr,
104: JAI_RGM_SETTLEMENTS jrs
105: WHERE jrr.settlement_id = jrs.settlement_id
106: AND jrr.source_document_date BETWEEN pd_rgm_from_date and pd_rgm_to_date
107: AND jrr.certificate_id IS NULL

Line 208: UPDATE jai_rgm_refs_all

204: OPEN c_get_certificate_id;
205: FETCH c_get_certificate_id INTO ln_certificate_id;
206: CLOSE c_get_certificate_id;
207:
208: UPDATE jai_rgm_refs_all
209: SET certificate_id = ln_certificate_id
210: , last_update_date = sysdate
211: , last_update_login = ln_last_update_login
212: where trx_ref_id in ( SELECT jrr.trx_ref_id

Line 213: FROM jai_rgm_refs_all jrr,

209: SET certificate_id = ln_certificate_id
210: , last_update_date = sysdate
211: , last_update_login = ln_last_update_login
212: where trx_ref_id in ( SELECT jrr.trx_ref_id
213: FROM jai_rgm_refs_all jrr,
214: jai_rgm_settlements jrs
215: WHERE jrr.settlement_id = jrs.settlement_id
216: AND jrr.source_document_date BETWEEN ld_from_date and ld_to_date
217: AND jrr.certificate_id IS NULL