APPS.JAI_AP_TCS_PROCESSING_PKG dependencies on JAI_RGM_REFS_ALL

Line 85: FROM JAI_RGM_REFS_ALL jrr,

81: jrr.party_id,
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

Line 188: UPDATE jai_rgm_refs_all

184: OPEN c_get_certificate_id;
185: FETCH c_get_certificate_id INTO ln_certificate_id;
186: CLOSE c_get_certificate_id;
187:
188: UPDATE jai_rgm_refs_all
189: SET certificate_id = ln_certificate_id
190: , last_update_date = sysdate
191: , last_update_login = ln_last_update_login
192: where trx_ref_id in ( SELECT jrr.trx_ref_id

Line 193: FROM jai_rgm_refs_all jrr,

189: SET certificate_id = ln_certificate_id
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