APPS.JAI_AR_GLDIST_TRIGGER_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 159: from JAI_RGM_ORG_REGNS_V

155: or 'PROPRIETARY FIRM' and if the Service Type is one mentioned in Rule 7 of Point of Taxation Rules 2011 i.e
156: 105-p, 105-q, 105-s, 105-t, 105-u, 105-za, 105-zzzzm*/
157: CURSOR cur_get_st_accrual_date(p_regime_id NUMBER, p_organization_id NUMBER, p_location_id NUMBER) IS
158: select to_date(attribute_value, 'DD/MM/YYYY')
159: from JAI_RGM_ORG_REGNS_V
160: where regime_id = p_regime_id
161: and organization_id = p_organization_id
162: and location_id = p_location_id
163: AND attribute_code = 'EFF_DATE_ST_PT'

Line 168: from JAI_RGM_ORG_REGNS_V

164: AND attribute_type_code = 'OTHERS'
165: AND registration_type = 'OTHERS'
166: AND (NOT EXISTS
167: (select '1'
168: from JAI_RGM_ORG_REGNS_V
169: where regime_id = p_regime_id
170: and attribute_code IN 'INV_ORG_CLASSIFICATION'
171: and attribute_value <> 'ORGANIZATION'
172: and organization_id = p_organization_id

Line 177: from JAI_RGM_ORG_REGNS_V

173: and location_id = p_location_id)
174: OR
175: NOT EXISTS
176: (select '1'
177: from JAI_RGM_ORG_REGNS_V
178: where regime_id = p_regime_id
179: and attribute_code IN 'SERVICE TYPE'
180: and attribute_value <> 'OTHER'
181: and organization_id = p_organization_id