APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 144: from JAI_RGM_ORG_REGNS_V

140: or 'PROPRIETARY FIRM' and if the Service Type is one mentioned in Rule 7 of Point of Taxation Rules 2011 i.e
141: 105-p, 105-q, 105-s, 105-t, 105-u, 105-za, 105-zzzzm*/
142: CURSOR c_get_st_accrual_date(p_regime_id NUMBER, p_organization_id NUMBER, p_location_id NUMBER) IS
143: select to_date(attribute_value, 'DD/MM/YYYY')
144: from JAI_RGM_ORG_REGNS_V
145: where regime_id = p_regime_id
146: and organization_id = p_organization_id
147: and location_id = p_location_id
148: AND attribute_code = 'EFF_DATE_ST_PT'

Line 153: from JAI_RGM_ORG_REGNS_V

149: AND attribute_type_code = 'OTHERS'
150: AND registration_type = 'OTHERS'
151: AND (NOT EXISTS
152: (select '1'
153: from JAI_RGM_ORG_REGNS_V
154: where regime_id = p_regime_id
155: and attribute_code IN 'INV_ORG_CLASSIFICATION'
156: and attribute_value <> 'ORGANIZATION'
157: and organization_id = p_organization_id

Line 162: from JAI_RGM_ORG_REGNS_V

158: and location_id = p_location_id)
159: OR
160: NOT EXISTS
161: (select '1'
162: from JAI_RGM_ORG_REGNS_V
163: where regime_id = p_regime_id
164: and attribute_code IN 'SERVICE TYPE'
165: and attribute_value <> 'OTHER'
166: and organization_id = p_organization_id