DBA Data[Home] [Help]

APPS.ZX_PTP_MIGRATE_PKG dependencies on HR_OPERATING_UNITS

Line 2288: FROM HR_OPERATING_UNITS

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'));

Line 2289: WHERE HR_OPERATING_UNITS.ORGANIZATION_ID =

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:

Line 2290: nvl(p_party_ID,HR_OPERATING_UNITS.ORGANIZATION_ID) and

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----------