DBA Data[Home] [Help]

APPS.JAI_AP_STND_TAX_PROCESS dependencies on JAI_RGM_ORG_REGNS_V

Line 4897: from JAI_RGM_ORG_REGNS_V

4893: --Added by zhiwei for POT change Bug#13023443 begin
4894: -----------------------------------------------------------------------
4895: CURSOR c_get_st_accrual_date(p_regime_id NUMBER, p_organization_id NUMBER, p_location_id NUMBER) IS
4896: select to_date(attribute_value, 'DD/MM/YYYY')
4897: from JAI_RGM_ORG_REGNS_V
4898: where regime_id = p_regime_id
4899: and organization_id = p_organization_id
4900: and location_id = p_location_id
4901: AND attribute_code = 'EFF_DATE_ST_PT'

Line 4906: from JAI_RGM_ORG_REGNS_V

4902: AND attribute_type_code = 'OTHERS'
4903: AND registration_type = 'OTHERS'
4904: AND (NOT EXISTS
4905: (select '1'
4906: from JAI_RGM_ORG_REGNS_V
4907: where regime_id = p_regime_id
4908: and attribute_code IN 'INV_ORG_CLASSIFICATION'
4909: and attribute_value <> 'ORGANIZATION'
4910: and organization_id = p_organization_id

Line 4915: from JAI_RGM_ORG_REGNS_V

4911: and location_id = p_location_id)
4912: OR
4913: NOT EXISTS
4914: (select '1'
4915: from JAI_RGM_ORG_REGNS_V
4916: where regime_id = p_regime_id
4917: and attribute_code IN 'SERVICE TYPE'
4918: and attribute_value <> 'OTHER'
4919: and organization_id = p_organization_id