APPS.GHR_US_NFC_EXTRACTS dependencies on PER_ALL_PEOPLE_F

Line 841: FROM per_all_people_f ppf

837: ,cp_effective_date DATE
838: )
839: IS
840: SELECT national_identifier
841: FROM per_all_people_f ppf
842: WHERE person_id=cp_person_id
843: AND ppf.business_group_id=p_business_group_id
844: AND p_effective_date BETWEEN ppf.effective_start_date
845: AND ppf.effective_end_date;

Line 1402: FROM per_all_people_f ppf

1398: l_temp NUMBER;
1399: l_proc_name constant varchar2(150) := g_proc_name ||'populate_attr';
1400: CURSOR c_get_pos_id IS
1401: SELECT ppf.sex
1402: FROM per_all_people_f ppf
1403: WHERE p_effective_date BETWEEN
1404: ppf.effective_start_date
1405: AND ppf.effective_end_date
1406: AND ppf.business_group_id=p_business_group_id

Line 5259: l_person_id per_all_people_f.person_id%type;

5255: l_ff_value ben_ext_rslt_dtl.val_01%type;
5256: l_ff_value_fmt ben_ext_rslt_dtl.val_01%type;
5257: l_max_len number;
5258: l_rqd_elmt_is_present varchar2(2) := 'Y';
5259: l_person_id per_all_people_f.person_id%type;
5260: --
5261: l_val_tab ValTabTyp;
5262: l_exclude_this_rcd_flag boolean;
5263: l_raise_warning boolean;