APPS.GHR_SF52_DO_UPDATE dependencies on PER_ALL_PEOPLE_F

Line 1082: from per_all_people_f

1078: -- Cursor to select the business_group_id that the person belongs to
1079:
1080: Cursor c_bgpid is
1081: select business_group_id
1082: from per_all_people_f
1083: where person_id = p_pa_request_rec.person_id
1084: and p_pa_request_rec.effective_date
1085: between effective_start_date and effective_end_date;
1086:

Line 2663: from per_all_people_f per

2659:
2660: cursor c_update_mode_p is
2661: select per.effective_start_date ,
2662: per.effective_end_date
2663: from per_all_people_f per
2664: where per.person_id = p_id
2665: and p_effective_date
2666: between per.effective_start_date
2667: and per.effective_end_date;

Line 2672: from per_all_people_f per

2668:
2669: cursor c_update_mode_p1 is
2670: select per.effective_start_date ,
2671: per.effective_end_date
2672: from per_all_people_f per
2673: where per.person_id = p_id
2674: and p_effective_date < per.effective_start_date;
2675:
2676:

Line 3044: from per_all_people_f per

3040: -- Business group of the person
3041:
3042: Cursor c_bus_gp is
3043: select per.business_group_id
3044: from per_all_people_f per
3045: where per.person_id = p_pa_request_rec.person_id
3046: and g_effective_date between
3047: per.effective_start_date
3048: and per.effective_end_date;

Line 3068: per_all_people_f ppf

3064: cursor c_person_type is
3065: Select ppt.system_person_type,
3066: ppf.person_type_id
3067: from per_person_types ppt,
3068: per_all_people_f ppf
3069: where ppf.person_id = P_pa_request_rec.person_id
3070: and ppt.person_type_id = ppf.person_type_id
3071: and g_effective_date between ppf.effective_start_date
3072: and ppf.effective_end_date;

Line 3206: from per_all_people_f ppf

3202: ppf.date_of_birth,
3203: ppf.first_name,
3204: ppf.last_name,
3205: ppf.middle_names
3206: from per_all_people_f ppf
3207: where ppf.person_id = P_pa_request_rec.person_id
3208: and g_effective_date between ppf.effective_start_date
3209: and ppf.effective_end_date;
3210:

Line 8226: from per_all_people_f

8222: l_date_from DATE;
8223:
8224: Cursor c_bgpid is
8225: select business_group_id
8226: from per_all_people_f
8227: where person_id = p_pa_request_rec.person_id;
8228:
8229: Cursor c_flex_num is
8230: select id_flex_num