APPS.IGS_GE_MNT_SDTT dependencies on PER_ALL_PEOPLE_F

Line 52: FROM per_all_people_f

48: WHERE system_type = cp_staff_var;
49:
50: CURSOR C_ALLPERSON (cp_person_id VARCHAR2) IS
51: SELECT 'X'
52: FROM per_all_people_f
53: WHERE party_id = cp_person_id;
54:
55: CURSOR C_OSSUSER (cp_staff_var VARCHAR2, cp_person_id VARCHAR2) IS
56: SELECT NVL(HZ.KNOWN_AS, SUBSTR (HZ.PERSON_FIRST_NAME, 1, DECODE(INSTR(HZ.PERSON_FIRST_NAME, ' '),

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