APPS.JA_CN_HRMS_EXPORT_PKG dependencies on PER_ALL_PEOPLE_F

Line 83: FROM PER_ALL_PEOPLE_F

79:
80: CURSOR c_check_person(p_person_id IN NUMBER,p_date IN DATE)
81: IS
82: SELECT '1'
83: FROM PER_ALL_PEOPLE_F
84: WHERE PERSON_ID = p_person_id
85: AND p_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
86:
87: CURSOR c_get_cit_ident_no(p_person_id IN NUMBER,p_date IN DATE)

Line 90: FROM PER_ALL_PEOPLE_F

86:
87: CURSOR c_get_cit_ident_no(p_person_id IN NUMBER,p_date IN DATE)
88: IS
89: SELECT NATIONAL_IDENTIFIER
90: FROM PER_ALL_PEOPLE_F
91: WHERE PERSON_ID = p_person_id
92: AND p_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
93:
94: CURSOR c_get_pass_no(p_person_id IN NUMBER)