DBA Data[Home] [Help]

APPS.ZX_PTP_MIGRATE_PKG dependencies on HR_OPERATING_UNITS

Line 2408: FROM HR_OPERATING_UNITS

2404: fnd_global.user_id, -- Last_Updated_By
2405: SYSDATE, -- Last_Update_Date
2406: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login
2407: 1
2408: FROM HR_OPERATING_UNITS
2409: WHERE HR_OPERATING_UNITS.ORGANIZATION_ID =
2410: nvl(p_party_ID,HR_OPERATING_UNITS.ORGANIZATION_ID) and
2411: not exists ( select 1 from zx_party_tax_profile
2412: WHERE party_id = organization_id and Party_Type_Code = 'OU'));

Line 2409: WHERE HR_OPERATING_UNITS.ORGANIZATION_ID =

2405: SYSDATE, -- Last_Update_Date
2406: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login
2407: 1
2408: FROM HR_OPERATING_UNITS
2409: WHERE HR_OPERATING_UNITS.ORGANIZATION_ID =
2410: nvl(p_party_ID,HR_OPERATING_UNITS.ORGANIZATION_ID) and
2411: not exists ( select 1 from zx_party_tax_profile
2412: WHERE party_id = organization_id and Party_Type_Code = 'OU'));
2413:

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

2406: FND_GLOBAL.CONC_LOGIN_ID, -- Last_Update_Login
2407: 1
2408: FROM HR_OPERATING_UNITS
2409: WHERE HR_OPERATING_UNITS.ORGANIZATION_ID =
2410: nvl(p_party_ID,HR_OPERATING_UNITS.ORGANIZATION_ID) and
2411: not exists ( select 1 from zx_party_tax_profile
2412: WHERE party_id = organization_id and Party_Type_Code = 'OU'));
2413:
2414: ------Bugfix 4308003----------