APPS.EGO_CHANGE_PEOPLE_IMPORT_PKG dependencies on HZ_PARTIES

Line 31: -- Seeded value for all_users (group available in hz_parties)

27:
28: --Indicates the object id (set using g_Fnd_Object_Name)
29: G_FND_OBJECT_ID fnd_objects.object_id%TYPE;
30:
31: -- Seeded value for all_users (group available in hz_parties)
32: G_ALL_USERS_PARTY_ID PLS_INTEGER := -1000;
33:
34: -- Batch size that needs to be processed
35: G_BATCH_SIZE PLS_INTEGER;

Line 243: FROM hz_parties

239: -- IN : object_name
240: --
241: CURSOR c_all_users_party_id IS
242: SELECT party_id
243: FROM hz_parties
244: WHERE party_type = 'GLOBAL'
245: AND party_name = 'All Users';
246:
247: BEGIN

Line 1259: l_login_party_id hz_parties.party_id%TYPE;

1255: l_token_tbl_one Error_Handler.Token_Tbl_Type;
1256: l_token_tbl_two Error_Handler.Token_Tbl_Type;
1257: l_token_tbl_three Error_Handler.Token_Tbl_Type;
1258:
1259: l_login_party_id hz_parties.party_id%TYPE;
1260: l_login_party_name VARCHAR2(240);
1261: l_cpi_lines_count PLS_INTEGER;
1262: l_loop_count PLS_INTEGER;
1263: l_transaction_id_min PLS_INTEGER;