APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on HR_GENERAL

Line 1254: l_display_los := NVL(l_yy,0)||' '||hr_general.decode_lookup('QUALIFYING_UNITS','Y')||' '||NVL(l_mm,0)||' '||hr_general.decode_lookup('QUALIFYING_UNITS','M')||' '||l_dd||' '||hr_general.decode_lookup('QUALIFYING_UNITS','D');

1250: l_temp_los_mm := l_temp_los_mm - l_yy*12;
1251: l_mm := NVL(TRUNC(l_temp_los_mm,0),0);
1252: l_dd := NVL(l_determination_date - TRUNC( ADD_MONTHS(l_adj_service_date,(l_mm+l_yy*12))),0);
1253:
1254: l_display_los := NVL(l_yy,0)||' '||hr_general.decode_lookup('QUALIFYING_UNITS','Y')||' '||NVL(l_mm,0)||' '||hr_general.decode_lookup('QUALIFYING_UNITS','M')||' '||l_dd||' '||hr_general.decode_lookup('QUALIFYING_UNITS','D');
1255:
1256: hr_utility.set_location(l_proc||l_display_los,15);
1257:
1258: hr_utility.set_location(l_proc||' Leaving',20);

Line 2755: || hr_general.decode_lookup ('QUALIFYING_UNITS', 'Y')

2751: );
2752: l_display_los :=
2753: NVL (l_yy, 0)
2754: || ' '
2755: || hr_general.decode_lookup ('QUALIFYING_UNITS', 'Y')
2756: || ' '
2757: || NVL (l_mm, 0)
2758: || ' '
2759: || hr_general.decode_lookup ('QUALIFYING_UNITS', 'M')

Line 2759: || hr_general.decode_lookup ('QUALIFYING_UNITS', 'M')

2755: || hr_general.decode_lookup ('QUALIFYING_UNITS', 'Y')
2756: || ' '
2757: || NVL (l_mm, 0)
2758: || ' '
2759: || hr_general.decode_lookup ('QUALIFYING_UNITS', 'M')
2760: || ' '
2761: || l_dd
2762: || ' '
2763: || hr_general.decode_lookup ('QUALIFYING_UNITS', 'D');

Line 2763: || hr_general.decode_lookup ('QUALIFYING_UNITS', 'D');

2759: || hr_general.decode_lookup ('QUALIFYING_UNITS', 'M')
2760: || ' '
2761: || l_dd
2762: || ' '
2763: || hr_general.decode_lookup ('QUALIFYING_UNITS', 'D');
2764: END IF;
2765:
2766: hr_utility.set_location (l_proc || l_display_los, 15);
2767: hr_utility.set_location (l_proc || ' Leaving', 20);