APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_RGM_DEFINITIONS

Line 258: FROM jai_rgm_definitions

254: CURSOR c_get_st_accrual_date(p_organization_id NUMBER, p_location_id NUMBER) IS
255: select to_date(attribute_value, 'DD/MM/YYYY')
256: from JAI_RGM_ORG_REGNS_V
257: where regime_id = (SELECT regime_id
258: FROM jai_rgm_definitions
259: where regime_code = jai_constants.service_regime
260: )
261: and organization_id = p_organization_id
262: and location_id = p_location_id

Line 270: FROM jai_rgm_definitions

266: AND (NOT EXISTS
267: (select '1'
268: from JAI_RGM_ORG_REGNS_V
269: where regime_id = (SELECT regime_id
270: FROM jai_rgm_definitions
271: where regime_code = jai_constants.service_regime
272: )
273: and attribute_code IN 'INV_ORG_CLASSIFICATION'
274: and attribute_value <> 'ORGANIZATION'

Line 282: FROM jai_rgm_definitions

278: NOT EXISTS
279: (select '1'
280: from JAI_RGM_ORG_REGNS_V
281: where regime_id = (SELECT regime_id
282: FROM jai_rgm_definitions
283: where regime_code = jai_constants.service_regime
284: )
285: and attribute_code IN 'SERVICE TYPE'
286: and attribute_value <> 'OTHER'

Line 2050: , jai_rgm_definitions jrd

2046: /*
2047: CURSOR c_get_st_accrual_date IS
2048: SELECT to_date(jrr.attribute_value, 'DD/MM/YYYY')
2049: FROM jai_rgm_registrations jrr
2050: , jai_rgm_definitions jrd
2051: WHERE jrr.regime_id = jrd.regime_id
2052: AND jrd.regime_code = jai_constants.service_regime
2053: AND jrr.attribute_code = 'EFF_DATE_ST_PT'
2054: AND jrr.attribute_type_code = 'OTHERS'

Line 2148: FROM jai_rgm_definitions

2144: CURSOR c_get_st_accrual_date(p_organization_id NUMBER, p_location_id NUMBER) IS
2145: select to_date(attribute_value, 'DD/MM/YYYY')
2146: from JAI_RGM_ORG_REGNS_V
2147: where regime_id = (SELECT regime_id
2148: FROM jai_rgm_definitions
2149: where regime_code = jai_constants.service_regime
2150: )
2151: and organization_id = p_organization_id
2152: and location_id = p_location_id

Line 2160: FROM jai_rgm_definitions

2156: AND (NOT EXISTS
2157: (select '1'
2158: from JAI_RGM_ORG_REGNS_V
2159: where regime_id = (SELECT regime_id
2160: FROM jai_rgm_definitions
2161: where regime_code = jai_constants.service_regime
2162: )
2163: and attribute_code IN 'INV_ORG_CLASSIFICATION'
2164: and attribute_value <> 'ORGANIZATION'

Line 2172: FROM jai_rgm_definitions

2168: NOT EXISTS
2169: (select '1'
2170: from JAI_RGM_ORG_REGNS_V
2171: where regime_id = (SELECT regime_id
2172: FROM jai_rgm_definitions
2173: where regime_code = jai_constants.service_regime
2174: )
2175: and attribute_code IN 'SERVICE TYPE'
2176: and attribute_value <> 'OTHER'