APPS.HR_MX_UTILITY dependencies on PER_ALL_PEOPLE_F

Line 286: p_person_id per_all_people_f.person_id%type)

282: -- --
283: --------------------------------------------------------------------------
284:
285: FUNCTION GET_BG_FROM_PERSON (
286: p_person_id per_all_people_f.person_id%type)
287: RETURN per_all_people_f.business_group_id%type AS
288:
289: CURSOR csr_fetch_bg IS
290: SELECT business_group_id

Line 287: RETURN per_all_people_f.business_group_id%type AS

283: --------------------------------------------------------------------------
284:
285: FUNCTION GET_BG_FROM_PERSON (
286: p_person_id per_all_people_f.person_id%type)
287: RETURN per_all_people_f.business_group_id%type AS
288:
289: CURSOR csr_fetch_bg IS
290: SELECT business_group_id
291: FROM per_people_f

Line 295: l_bg_id per_all_people_f.business_group_id%type;

291: FROM per_people_f
292: WHERE person_id = p_person_id
293: AND rownum < 2;
294:
295: l_bg_id per_all_people_f.business_group_id%type;
296:
297: BEGIN
298: OPEN csr_fetch_bg;
299: FETCH csr_fetch_bg INTO l_bg_id;

Line 875: per_all_people_f pap

871: CURSOR c_get_adj_svc_date
872: IS
873: SELECT pps.adjusted_svc_date
874: FROM per_periods_of_service pps,
875: per_all_people_f pap
876: WHERE pap.person_id = p_person_id
877: AND pps.person_id = pap.person_id
878: AND p_effective_date BETWEEN pap.effective_start_date
879: AND pap.effective_end_date

Line 890: FROM per_all_people_f

886: -- cursor to get the start_date or original_date_of_hire
887: CURSOR c_get_hire_date
888: IS
889: SELECT NVL(original_date_of_hire, start_date)
890: FROM per_all_people_f
891: WHERE person_id = p_person_id
892: ORDER BY 1 desc;
893:
894: ld_adj_svc_date DATE;