APPS.PER_CN_SHARED_INFO dependencies on PER_PEOPLE_EXTRA_INFO

Line 62: FROM PER_PEOPLE_EXTRA_INFO

58: AND p_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
59:
60: CURSOR c_get_pass_no(p_person_id IN NUMBER) IS
61: SELECT PEI_INFORMATION1 A, PEI_INFORMATION2 B
62: FROM PER_PEOPLE_EXTRA_INFO
63: WHERE PERSON_ID = p_person_id
64: AND INFORMATION_TYPE = 'PER_PASS_INFO_CN'
65: AND PEI_INFORMATION_CATEGORY = 'PER_PASS_INFO_CN'
66: ORDER BY A;

Line 70: FROM PER_PEOPLE_EXTRA_INFO

66: ORDER BY A;
67:
68: CURSOR c_get_passport_no(p_person_id IN NUMBER) IS
69: SELECT PEI_INFORMATION2
70: FROM PER_PEOPLE_EXTRA_INFO
71: WHERE PERSON_ID = p_person_id
72: AND INFORMATION_TYPE = 'PER_PASSPORT_INFO_CN'
73: AND PEI_INFORMATION_CATEGORY = 'PER_PASSPORT_INFO_CN';
74: