APPS.HR_MISC_WEB dependencies on PER_ALL_PEOPLE_F

Line 191: ( p_bg_id IN per_all_people_f.business_group_id%TYPE DEFAULT NULL,

187: --||===========================================================================
188: */
189:
190: FUNCTION get_sshr_segment_value
191: ( p_bg_id IN per_all_people_f.business_group_id%TYPE DEFAULT NULL,
192: p_user_column_name IN varchar2 )
193: RETURN VARCHAR2
194: IS
195:

Line 387: ( p_bg_id IN per_all_people_f.business_group_id%TYPE,

383: */
384:
385:
386: FUNCTION get_job_segments
387: ( p_bg_id IN per_all_people_f.business_group_id%TYPE,
388: p_job_id IN hr_organization_units.organization_id%TYPE,
389: p_job_name IN hr_organization_units.name%TYPE)
390: RETURN VARCHAR2
391: IS

Line 453: FROM per_all_people_f

449: p_person_id IN per_people_f.person_id%TYPE
450: ) IS
451: SELECT full_name,
452: business_group_id
453: FROM per_all_people_f
454: WHERE person_id = p_person_id
455: AND TRUNC(SYSDATE) BETWEEN effective_start_date
456: AND NVL(effective_end_date, TRUNC(SYSDATE));
457:

Line 517: FROM per_all_people_f ppf,

513: paf.payroll_id,
514: paf.location_id,
515: paf.primary_flag,
516: paf.object_version_number
517: FROM per_all_people_f ppf,
518: per_all_assignments_f paf
519: WHERE paf.assignment_id = p_assignment_id
520: AND paf.person_id = ppf.person_id
521: AND p_effective_date BETWEEN paf.effective_start_date

Line 547: FROM per_all_people_f ppf,

543: p_effective_date IN DATE
544: ) IS
545: SELECT ppf.person_id,
546: ppf.full_name
547: FROM per_all_people_f ppf,
548: per_all_assignments_f paf
549: WHERE paf.assignment_id = p_assignment_id
550: AND paf.supervisor_id = ppf.person_id
551: -- AND paf.primary_flag = 'Y' -- To supprot multiple assignments

Line 1044: FROM per_all_people_f per

1040: SELECT pbg.legislation_code
1041: FROM per_business_groups pbg
1042: WHERE pbg.business_group_id IN
1043: (SELECT per.business_group_id
1044: FROM per_all_people_f per
1045: WHERE per.person_id = p_person_id
1046: AND TRUNC(p_effective_date) BETWEEN per.effective_start_date
1047: AND NVL(per.effective_end_date, TRUNC(SYSDATE)));
1048:

Line 1073: FROM per_all_people_f ppf

1069: -- performance because base tables are used instead of views. These cursors
1070: -- are similar to SSHR V4 common module code.
1071: CURSOR csr_per_leg_code is
1072: SELECT org.org_information9 legislation_code
1073: FROM per_all_people_f ppf
1074: ,hr_organization_information org
1075: WHERE org.organization_id = ppf.business_group_id
1076: AND org.org_information_context = 'Business Group Information'
1077: AND ppf.person_id = p_person_id