APPS.GHR_SF52_DO_UPDATE dependencies on PER_ALL_PEOPLE_F

Line 1097: from per_all_people_f

1093: -- Cursor to select the business_group_id that the person belongs to
1094:
1095: Cursor c_bgpid is
1096: select business_group_id
1097: from per_all_people_f
1098: where person_id = p_pa_request_rec.person_id
1099: and p_pa_request_rec.effective_date
1100: between effective_start_date and effective_end_date;
1101:

Line 2867: from per_all_people_f per

2863:
2864: cursor c_update_mode_p is
2865: select per.effective_start_date ,
2866: per.effective_end_date
2867: from per_all_people_f per
2868: where per.person_id = p_id
2869: and p_effective_date
2870: between per.effective_start_date
2871: and per.effective_end_date;

Line 2876: from per_all_people_f per

2872:
2873: cursor c_update_mode_p1 is
2874: select per.effective_start_date ,
2875: per.effective_end_date
2876: from per_all_people_f per
2877: where per.person_id = p_id
2878: and p_effective_date < per.effective_start_date;
2879:
2880:

Line 3248: from per_all_people_f per

3244: -- Business group of the person
3245:
3246: Cursor c_bus_gp is
3247: select per.business_group_id
3248: from per_all_people_f per
3249: where per.person_id = p_pa_request_rec.person_id
3250: and g_effective_date between
3251: per.effective_start_date
3252: and per.effective_end_date;

Line 3272: per_all_people_f ppf

3268: cursor c_person_type is
3269: Select ppt.system_person_type,
3270: ppf.person_type_id
3271: from per_person_types ppt,
3272: per_all_people_f ppf
3273: where ppf.person_id = P_pa_request_rec.person_id
3274: and ppt.person_type_id = ppf.person_type_id
3275: and g_effective_date between ppf.effective_start_date
3276: and ppf.effective_end_date;

Line 3411: from per_all_people_f ppf

3407: ppf.date_of_birth,
3408: ppf.first_name,
3409: ppf.last_name,
3410: ppf.middle_names
3411: from per_all_people_f ppf
3412: where ppf.person_id = P_pa_request_rec.person_id
3413: and g_effective_date between ppf.effective_start_date
3414: and ppf.effective_end_date;
3415:

Line 8529: from per_all_people_f

8525: l_date_from DATE;
8526:
8527: Cursor c_bgpid is
8528: select business_group_id
8529: from per_all_people_f
8530: where person_id = p_pa_request_rec.person_id;
8531:
8532: Cursor c_flex_num is
8533: select id_flex_num