APPS.EGO_ITEM_PEOPLE_IMPORT_PKG dependencies on EGO_PEOPLE_V

Line 1723: -- 5375467 modified query to validate user against ego_people_v

1719: -- );
1720: --
1721: -- TYPE Token_Tbl_Type IS TABLE OF Token_Rec_Type INDEX BY BINARY_INTEGER;
1722: -- ======================================================================
1723: -- 5375467 modified query to validate user against ego_people_v
1724: CURSOR c_user_party_id (cp_user_id IN NUMBER) IS
1725: SELECT person_id, person_name
1726: FROM ego_people_v
1727: WHERE user_id = cp_user_id;

Line 1726: FROM ego_people_v

1722: -- ======================================================================
1723: -- 5375467 modified query to validate user against ego_people_v
1724: CURSOR c_user_party_id (cp_user_id IN NUMBER) IS
1725: SELECT person_id, person_name
1726: FROM ego_people_v
1727: WHERE user_id = cp_user_id;
1728:
1729: CURSOR c_count_ipi_lines (cp_data_set_id IN NUMBER) IS
1730: SELECT COUNT(*)

Line 2318: FROM ego_people_v

2314: -------------------------------------------------------------------------
2315: UPDATE ego_item_people_intf eipi
2316: SET (eipi.grantee_party_id) =
2317: ( SELECT person_id
2318: FROM ego_people_v
2319: WHERE UPPER(user_name) = UPPER(eipi.grantee_name)
2320: )
2321: WHERE eipi.data_set_id = G_DATA_SET_ID
2322: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER