APPS.JA_CN_PS_HRMS_EXPORT_PKG dependencies on PER_ALL_PEOPLE_F
Line 130: per_all_people_f
126: IS
127: SELECT
128: '1'
129: FROM 130: per_all_people_f 131: WHERE person_id = pn_person_id
132: AND pd_date BETWEEN effective_start_date AND effective_end_date;
133:
134: CURSOR c_get_cit_ident_no
Line 142: per_all_people_f
138: IS
139: SELECT
140: national_identifier
141: FROM 142: per_all_people_f 143: WHERE person_id = pn_person_id
144: AND pd_date BETWEEN effective_start_date AND effective_end_date;
145:
146: CURSOR cur_get_pass_no