APPS.PER_CN_SHARED_INFO dependencies on PER_ALL_PEOPLE_F

Line 50: FROM PER_ALL_PEOPLE_F

46: l_doc_num VARCHAR2(100);
47:
48: CURSOR c_check_person(p_person_id IN NUMBER,p_date IN DATE) IS
49: SELECT '1'
50: FROM PER_ALL_PEOPLE_F
51: WHERE PERSON_ID = p_person_id
52: AND p_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
53:
54: CURSOR c_get_cit_ident_no(p_person_id IN NUMBER,p_date IN DATE) IS

Line 56: FROM PER_ALL_PEOPLE_F

52: AND p_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
53:
54: CURSOR c_get_cit_ident_no(p_person_id IN NUMBER,p_date IN DATE) IS
55: SELECT NATIONAL_IDENTIFIER
56: FROM PER_ALL_PEOPLE_F
57: WHERE PERSON_ID = p_person_id
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