APPS.HXC_PREFERENCE_EVALUATION dependencies on PER_ALL_PEOPLE_F

Line 2909: p_person_id per_all_people_f.person_id%TYPE,

2905: || l_proc, 100);
2906: end if;
2907: END set_migration_mode;
2908: FUNCTION employment_ended (
2909: p_person_id per_all_people_f.person_id%TYPE,
2910: p_effective_date per_all_assignments_f.effective_start_date%TYPE
2911: DEFAULT SYSDATE
2912: )
2913: RETURN BOOLEAN

Line 2919: p_person_id per_all_people_f.person_id%TYPE,

2915: l_proc VARCHAR2 (72);
2916: l_employment_ended BOOLEAN;
2917:
2918: CURSOR csr_existing_employment (
2919: p_person_id per_all_people_f.person_id%TYPE,
2920: p_effective_date per_all_assignments_f.effective_start_date%TYPE
2921: )
2922: IS
2923: SELECT 1

Line 2968: p_person_id per_all_people_f.person_id%TYPE,

2964: RETURN l_employment_ended;
2965: END employment_ended;
2966:
2967: FUNCTION assignment_last_eff_dt (
2968: p_person_id per_all_people_f.person_id%TYPE,
2969: p_effective_date per_all_assignments_f.effective_start_date%TYPE
2970: DEFAULT SYSDATE
2971: )
2972: RETURN per_all_assignments_f.effective_start_date%TYPE

Line 2978: p_person_id per_all_people_f.person_id%TYPE,

2974: l_proc VARCHAR2 (72);
2975: l_assignment_last_eff_dt per_all_assignments_f.effective_start_date%TYPE;
2976:
2977: CURSOR csr_assignment_last_eff_dt (
2978: p_person_id per_all_people_f.person_id%TYPE,
2979: p_effective_date per_all_assignments_f.effective_start_date%TYPE
2980: )
2981: IS
2982: SELECT MAX (paaf.effective_end_date)