APPS.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 36: from JAI_RGM_ORG_REGNS_V

32: 105-p, 105-q, 105-s, 105-t, 105-u, 105-za, 105-zzzzm*/
33:
34: CURSOR c_get_st_accrual_date(p_organization_id NUMBER, p_location_id NUMBER) IS
35: select to_date(attribute_value, 'DD/MM/YYYY')
36: from JAI_RGM_ORG_REGNS_V
37: where regime_id IN (SELECT regime_id
38: FROM jai_rgm_definitions
39: WHERE regime_code = jai_constants.service_regime
40: )

Line 48: from JAI_RGM_ORG_REGNS_V

44: AND attribute_type_code = 'OTHERS'
45: AND registration_type = 'OTHERS'
46: AND (NOT EXISTS
47: (select '1'
48: from JAI_RGM_ORG_REGNS_V
49: where regime_id IN (SELECT regime_id
50: FROM jai_rgm_definitions
51: WHERE regime_code = jai_constants.service_regime
52: )

Line 60: from JAI_RGM_ORG_REGNS_V

56: and location_id = p_location_id)
57: OR
58: NOT EXISTS
59: (select '1'
60: from JAI_RGM_ORG_REGNS_V
61: where regime_id IN (SELECT regime_id
62: FROM jai_rgm_definitions
63: WHERE regime_code = jai_constants.service_regime
64: )