65: ||DECODE(p_first_name,NULL, '', ' ' || p_first_name)
66: ||DECODE(p_middle_names,NULL, '', ' ' || p_middle_names)
67: )), 1, 240)
68: INTO l_full_name
69: FROM dual;
70:
71: RETURN(l_full_name);
72: --
73: END per_mx_full_name;
945: SELECT CEIL((p_effective_date - get_hire_anniversary (
946: p_person_id,
947: p_effective_date))/365)
948: INTO ln_seniority_years
949: FROM DUAL ; */
950:
951: SELECT (p_effective_date - get_hire_anniversary (
952: p_person_id,
953: p_effective_date))/365
951: SELECT (p_effective_date - get_hire_anniversary (
952: p_person_id,
953: p_effective_date))/365
954: INTO ln_seniority_years
955: FROM DUAL ;
956:
957: IF ln_seniority_years < 0 THEN
958:
959: ln_seniority_years := 0;
1021: -- calculate seniority years
1022:
1023: SELECT ROUND( (p_effective_date - ld_hire_date) / ln_days_in_a_year )
1024: INTO ln_seniority_years
1025: FROM DUAL ;
1026:
1027: IF ln_seniority_years < 0 THEN
1028:
1029: ln_seniority_years := 0;