DBA Data[Home] [Help]

APPS.EGO_CHANGE_PEOPLE_IMPORT_PKG dependencies on EGO_GROUPS_V

Line 1623: FROM ego_groups_v

1619: --Update the grantee_party id column for the groups
1620: UPDATE eng_change_people_intf ecpi
1621: SET ecpi.grantee_party_id =
1622: ( SELECT group_id
1623: FROM ego_groups_v
1624: WHERE upper(group_name) = upper(ecpi.grantee_name)
1625: )
1626: WHERE ecpi.data_set_id = G_DATA_SET_ID
1627: AND ecpi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER