APPS.IGS_EN_GEN_LEGACY dependencies on FND_USER

Line 1242: CURSOR get_usr_id_cur(cp_person_id fnd_user.person_party_id%type) IS

1238: IS SELECT person_type_code FROM igs_pe_person_types
1239: WHERE SYSTEM_TYPE = p_system_type
1240: AND CLOSED_IND = 'N';
1241:
1242: CURSOR get_usr_id_cur(cp_person_id fnd_user.person_party_id%type) IS
1243: SELECT user_id
1244: FROM fnd_user
1245: WHERE person_party_id = cp_person_id;
1246:

Line 1244: FROM fnd_user

1240: AND CLOSED_IND = 'N';
1241:
1242: CURSOR get_usr_id_cur(cp_person_id fnd_user.person_party_id%type) IS
1243: SELECT user_id
1244: FROM fnd_user
1245: WHERE person_party_id = cp_person_id;
1246:
1247: CURSOR cur_pe_seq IS SELECT IGS_PE_TYPE_INSTANCES_S.NEXTVAL FROM DUAL;
1248:

Line 1253: l_user_id fnd_user.user_id%TYPE;

1249: l_method VARCHAR2(50) := 'PERSON_ENROL_UNIT_SECT';
1250: l_error NUMBER := 0;
1251: l_person_type_code igs_pe_person_types.person_type_code%TYPE;
1252: l_type_instance_id igs_pe_typ_instances.type_instance_id%TYPE;
1253: l_user_id fnd_user.user_id%TYPE;
1254: l_sysdate DATE := TRUNC(SYSDATE);
1255: BEGIN
1256: -- Person Type business event should be raised only if the person is associated with a User
1257: OPEN get_usr_id_cur(p_person_id);