APPS.EGO_ITEM_PEOPLE_IMPORT_PKG dependencies on EGO_PEOPLE_V

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

1473: -- );
1474: --
1475: -- TYPE Token_Tbl_Type IS TABLE OF Token_Rec_Type INDEX BY BINARY_INTEGER;
1476: -- ======================================================================
1477: -- 5375467 modified query to validate user against ego_people_v
1478: CURSOR c_user_party_id (cp_user_id IN NUMBER) IS
1479: SELECT person_id, person_name
1480: FROM ego_people_v
1481: WHERE user_id = cp_user_id;

Line 1480: FROM ego_people_v

1476: -- ======================================================================
1477: -- 5375467 modified query to validate user against ego_people_v
1478: CURSOR c_user_party_id (cp_user_id IN NUMBER) IS
1479: SELECT person_id, person_name
1480: FROM ego_people_v
1481: WHERE user_id = cp_user_id;
1482:
1483: CURSOR c_count_ipi_lines (cp_data_set_id IN NUMBER) IS
1484: SELECT COUNT(*)

Line 2046: FROM ego_people_v

2042: -------------------------------------------------------------------------
2043: UPDATE ego_item_people_intf eipi
2044: SET (eipi.grantee_party_id) =
2045: ( SELECT person_id
2046: FROM ego_people_v
2047: WHERE UPPER(user_name) = UPPER(eipi.grantee_name)
2048: )
2049: WHERE eipi.data_set_id = G_DATA_SET_ID
2050: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER