DBA Data[Home] [Help]

APPS.JAI_AR_MATCH_TAX_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 4842: from JAI_RGM_ORG_REGNS_V

4838: or 'PROPRIETARY FIRM' and if the Service Type is one mentioned in Rule 7 of Point of Taxation Rules 2011 i.e
4839: 105-p, 105-q, 105-s, 105-t, 105-u, 105-za, 105-zzzzm*/
4840: CURSOR c_get_st_accrual_date(p_regime_id NUMBER, p_organization_id NUMBER, p_location_id NUMBER) IS
4841: select to_date(attribute_value, 'DD/MM/YYYY')
4842: from JAI_RGM_ORG_REGNS_V
4843: where regime_id = p_regime_id
4844: and organization_id = p_organization_id
4845: and location_id = p_location_id
4846: AND attribute_code = 'EFF_DATE_ST_PT'

Line 4851: from JAI_RGM_ORG_REGNS_V

4847: AND attribute_type_code = 'OTHERS'
4848: AND registration_type = 'OTHERS'
4849: AND (NOT EXISTS
4850: (select '1'
4851: from JAI_RGM_ORG_REGNS_V
4852: where regime_id = p_regime_id
4853: and attribute_code IN 'INV_ORG_CLASSIFICATION'
4854: and attribute_value <> 'ORGANIZATION'
4855: and organization_id = p_organization_id

Line 4860: from JAI_RGM_ORG_REGNS_V

4856: and location_id = p_location_id)
4857: OR
4858: NOT EXISTS
4859: (select '1'
4860: from JAI_RGM_ORG_REGNS_V
4861: where regime_id = p_regime_id
4862: and attribute_code IN 'SERVICE TYPE'
4863: and attribute_value <> 'OTHER'
4864: and organization_id = p_organization_id