DBA Data[Home] [Help]

APPS.HZ_POPULATE_BOT_PKG dependencies on HZ_ORG_PROFILES_EXT_B

Line 3774: FROM HZ_ORG_PROFILES_EXT_B c, HZ_ORGANIZATION_PROFILES p

3770:
3771: -- cursor statement to select the info from child table
3772: CURSOR C_child_org IS
3773: SELECT c.LAST_UPDATE_DATE lud, p.PARTY_ID parent_id, c.extension_id child_id, 'ORG' bo_code, 'HZ_PARTIES' parent_entity
3774: FROM HZ_ORG_PROFILES_EXT_B c, HZ_ORGANIZATION_PROFILES p
3775: WHERE c.EXTENSION_ID = P_EXTENSION_ID
3776: AND c.ORGANIZATION_PROFILE_ID = p.ORGANIZATION_PROFILE_ID
3777: AND rownum = 1;
3778: