APPS.HR_MISC_WEB dependencies on PER_PEOPLE_F

Line 438: p_person_id IN per_people_f.person_id%TYPE

434: ||
435: ||===========================================================================
436: */
437: FUNCTION get_person_details (
438: p_person_id IN per_people_f.person_id%TYPE
439: )
440: RETURN hr_misc_web.grt_person_details
441: IS
442:

Line 449: p_person_id IN per_people_f.person_id%TYPE

445: --
446: --1839081
447: --
448: CURSOR lc_person_details (
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

Line 693: p_person_id IN per_people_f.person_id%TYPE

689: ||
690: ||===========================================================================
691: */
692: FUNCTION get_assignment_id (
693: p_person_id IN per_people_f.person_id%TYPE
694: )
695: RETURN hr_misc_web.grt_assignment_details
696: IS
697:

Line 704: CURSOR lc_get_assignment (p_person_id IN per_people_f.person_id%TYPE)

700:
701: --
702: --1839081
703: --
704: CURSOR lc_get_assignment (p_person_id IN per_people_f.person_id%TYPE)
705: IS
706: SELECT paf.assignment_id, paf.effective_start_date
707: FROM per_all_assignments_f paf
708: WHERE paf.person_id = p_person_id

Line 961: p_person_id IN per_people_f.person_id%TYPE

957: ||
958: ||===========================================================================
959: */
960: FUNCTION get_business_group_id (
961: p_person_id IN per_people_f.person_id%TYPE
962: )
963: RETURN per_business_groups.business_group_id%TYPE
964: IS
965:

Line 967: l_person_rec per_people_f%ROWTYPE;

963: RETURN per_business_groups.business_group_id%TYPE
964: IS
965:
966: -- Local Variables.
967: l_person_rec per_people_f%ROWTYPE;
968:
969: BEGIN
970:
971: l_person_rec := hr_util_misc_web.get_person_rec (

Line 1021: p_person_id IN per_people_f.person_id%TYPE DEFAULT NULL,

1017: ||
1018: ||===========================================================================
1019: */
1020: FUNCTION get_legislation_code (
1021: p_person_id IN per_people_f.person_id%TYPE DEFAULT NULL,
1022: p_assignment_id IN per_assignments_f.assignment_id%TYPE DEFAULT NULL,
1023: p_business_group_id IN per_business_groups.business_group_id%TYPE
1024: DEFAULT NULL,
1025: p_effective_date IN DATE DEFAULT SYSDATE