APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 314: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd

310: 105-p, 105-q, 105-s, 105-t, 105-u, 105-za, 105-zzzzm*/
311:
312: CURSOR c_get_st_accrual_date(p_organization_id NUMBER, p_location_id NUMBER) IS
313: select to_date(attribute_value, 'DD/MM/YYYY')
314: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd
315: where jrr.regime_id = jrd.regime_id
316: AND jrd.regime_code = jai_constants.service_regime
317: and jrr.organization_id = p_organization_id
318: and jrr.location_id = p_location_id

Line 324: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd

320: AND jrr.attribute_type_code = 'OTHERS'
321: AND jrr.registration_type = 'OTHERS'
322: AND (NOT EXISTS
323: (select '1'
324: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd
325: where jrr.regime_id = jrd.regime_id
326: AND jrd.regime_code = jai_constants.service_regime
327: and jrr.attribute_code IN 'INV_ORG_CLASSIFICATION'
328: and jrr.attribute_value <> 'ORGANIZATION'

Line 334: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd

330: and jrr.location_id = p_location_id)
331: OR
332: NOT EXISTS
333: (select '1'
334: from JAI_RGM_ORG_REGNS_V jrr, jai_rgm_definitions jrd
335: where jrr.regime_id = jrd.regime_id
336: AND jrd.regime_code = jai_constants.service_regime
337: and jrr.attribute_code IN 'SERVICE TYPE'
338: and jrr.attribute_value <> 'OTHER'

Line 5115: JAI_RGM_ORG_REGNS_V rgm_attr_v

5111: SELECT
5112: regime_id ,
5113: attribute_value org_tan_no
5114: FROM
5115: JAI_RGM_ORG_REGNS_V rgm_attr_v
5116: WHERE
5117: rgm_attr_v.regime_code = cp_regime_code
5118: AND rgm_attr_v.attribute_code = cp_attribute_code
5119: AND rgm_attr_v.organization_id = cp_organization_id