APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 256: from JAI_RGM_ORG_REGNS_V

252: 105-p, 105-q, 105-s, 105-t, 105-u, 105-za, 105-zzzzm*/
253:
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: )

Line 268: from JAI_RGM_ORG_REGNS_V

264: AND attribute_type_code = 'OTHERS'
265: AND registration_type = 'OTHERS'
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: )

Line 280: from JAI_RGM_ORG_REGNS_V

276: and location_id = p_location_id)
277: OR
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: )

Line 2146: from JAI_RGM_ORG_REGNS_V

2142: 105-p, 105-q, 105-s, 105-t, 105-u, 105-za, 105-zzzzm*/
2143:
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: )

Line 2158: from JAI_RGM_ORG_REGNS_V

2154: AND attribute_type_code = 'OTHERS'
2155: AND registration_type = 'OTHERS'
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: )

Line 2170: from JAI_RGM_ORG_REGNS_V

2166: and location_id = p_location_id)
2167: OR
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: )