APPS.HR_MX_UTILITY dependencies on DUAL

Line 69: FROM dual;

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;

Line 947: FROM DUAL ;

943: SELECT CEIL((p_effective_date - get_hire_anniversary (
944: p_person_id,
945: p_effective_date))/365)
946: INTO ln_seniority_years
947: FROM DUAL ;
948:
949: IF ln_seniority_years < 0 THEN
950:
951: ln_seniority_years := 0;

Line 1013: FROM DUAL ;

1009: -- calculate seniority years
1010:
1011: SELECT ROUND( (p_effective_date - ld_hire_date) / ln_days_in_a_year )
1012: INTO ln_seniority_years
1013: FROM DUAL ;
1014:
1015: IF ln_seniority_years < 0 THEN
1016:
1017: ln_seniority_years := 0;