2284: fnd_global.user_id, -- Last_Updated_By
2285: SYSDATE, -- Last_Update_Date
2286: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login
2287: 1
2288: FROM HR_OPERATING_UNITS
2289: WHERE HR_OPERATING_UNITS.ORGANIZATION_ID =
2290: nvl(p_party_ID,HR_OPERATING_UNITS.ORGANIZATION_ID) and
2291: not exists ( select 1 from zx_party_tax_profile
2292: WHERE party_id = organization_id and Party_Type_Code = 'OU'));
2285: SYSDATE, -- Last_Update_Date
2286: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login
2287: 1
2288: FROM HR_OPERATING_UNITS
2289: WHERE HR_OPERATING_UNITS.ORGANIZATION_ID =
2290: nvl(p_party_ID,HR_OPERATING_UNITS.ORGANIZATION_ID) and
2291: not exists ( select 1 from zx_party_tax_profile
2292: WHERE party_id = organization_id and Party_Type_Code = 'OU'));
2293:
2286: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login
2287: 1
2288: FROM HR_OPERATING_UNITS
2289: WHERE HR_OPERATING_UNITS.ORGANIZATION_ID =
2290: nvl(p_party_ID,HR_OPERATING_UNITS.ORGANIZATION_ID) and
2291: not exists ( select 1 from zx_party_tax_profile
2292: WHERE party_id = organization_id and Party_Type_Code = 'OU'));
2293:
2294: ------Bugfix 4308003----------