APPS.JAI_TAX_PROCESSING_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 1614: from JAI_RGM_ORG_REGNS_V

1610: AND ap.line_number = pn_line_number;
1611:
1612: CURSOR c_get_st_accrual_date(p_regime_id NUMBER, p_organization_id NUMBER, p_location_id NUMBER) IS
1613: select to_date(attribute_value, 'DD/MM/YYYY')
1614: from JAI_RGM_ORG_REGNS_V
1615: where regime_id = p_regime_id
1616: and organization_id = p_organization_id
1617: and location_id = p_location_id
1618: AND attribute_code = 'EFF_DATE_ST_PT'

Line 1623: from JAI_RGM_ORG_REGNS_V

1619: AND attribute_type_code = 'OTHERS'
1620: AND registration_type = 'OTHERS'
1621: AND (NOT EXISTS
1622: (select '1'
1623: from JAI_RGM_ORG_REGNS_V
1624: where regime_id = p_regime_id
1625: and attribute_code IN 'INV_ORG_CLASSIFICATION'
1626: and attribute_value <> 'ORGANIZATION'
1627: and organization_id = p_organization_id

Line 1632: from JAI_RGM_ORG_REGNS_V

1628: and location_id = p_location_id)
1629: OR
1630: NOT EXISTS
1631: (select '1'
1632: from JAI_RGM_ORG_REGNS_V
1633: where regime_id = p_regime_id
1634: and attribute_code IN 'SERVICE TYPE'
1635: and attribute_value <> 'OTHER'
1636: and organization_id = p_organization_id