APPS.IGS_GE_MNT_SDTT dependencies on IGS_PE_PER_TYPE_MAP

Line 47: FROM igs_pe_per_type_map

43: l_all_person VARCHAR2(25);
44:
45: CURSOR C_STAFF (cp_staff_var VARCHAR2) IS
46: SELECT 'X'
47: FROM igs_pe_per_type_map
48: WHERE system_type = cp_staff_var;
49:
50: CURSOR C_ALLPERSON (cp_person_id VARCHAR2) IS
51: SELECT 'X'

Line 72: FROM PER_PERSON_TYPE_USAGES_F USG,PER_ALL_PEOPLE_F PEO,IGS_PE_PER_TYPE_MAP MAP,HZ_PARTIES HZ

68: CURSOR C_HRUSER (cp_staff_var VARCHAR2, cp_person_id VARCHAR2) IS
69: SELECT NVL(HZ.KNOWN_AS, SUBSTR (HZ.PERSON_FIRST_NAME, 1, DECODE(INSTR(HZ.PERSON_FIRST_NAME, ' '),
70: 0, LENGTH(HZ.PERSON_FIRST_NAME), (INSTR(HZ.PERSON_FIRST_NAME, ' ')-1)))) || ' ' || HZ.PERSON_LAST_NAME
71: PREFERRED_NAME
72: FROM PER_PERSON_TYPE_USAGES_F USG,PER_ALL_PEOPLE_F PEO,IGS_PE_PER_TYPE_MAP MAP,HZ_PARTIES HZ
73: WHERE HZ.PARTY_ID = peo.party_id
74: AND USG.PERSON_ID = PEO.PERSON_ID
75: AND HZ.PARTY_ID = cp_person_id
76: AND USG.PERSON_TYPE_ID = MAP.PER_PERSON_TYPE_ID