APPS.PAY_FR_GENERAL dependencies on HR_GENERAL

Line 2520: l_formatted_name := l_maiden_name||' '||hr_general.decode_lookup('NAME_TRANSLATIONS','FR_EPOUSE')||' '||l_last_name||' '||l_first_name;

2516:
2517: IF l_sex = 'F' THEN
2518:
2519: IF l_marital_status = 'M' THEN -- Married
2520: l_formatted_name := l_maiden_name||' '||hr_general.decode_lookup('NAME_TRANSLATIONS','FR_EPOUSE')||' '||l_last_name||' '||l_first_name;
2521:
2522: ELSIF l_marital_status = 'W' THEN -- Widowed
2523: l_formatted_name := l_maiden_name ||' '||hr_general.decode_lookup('NAME_TRANSLATIONS','FR_VEUVE')||' '||l_last_name||' '||l_first_name;
2524:

Line 2523: l_formatted_name := l_maiden_name ||' '||hr_general.decode_lookup('NAME_TRANSLATIONS','FR_VEUVE')||' '||l_last_name||' '||l_first_name;

2519: IF l_marital_status = 'M' THEN -- Married
2520: l_formatted_name := l_maiden_name||' '||hr_general.decode_lookup('NAME_TRANSLATIONS','FR_EPOUSE')||' '||l_last_name||' '||l_first_name;
2521:
2522: ELSIF l_marital_status = 'W' THEN -- Widowed
2523: l_formatted_name := l_maiden_name ||' '||hr_general.decode_lookup('NAME_TRANSLATIONS','FR_VEUVE')||' '||l_last_name||' '||l_first_name;
2524:
2525: ELSE
2526:
2527: IF l_last_name = l_maiden_name THEN

Line 2530: l_formatted_name := l_maiden_name||' '||hr_general.decode_lookup('NAME_TRANSLATIONS','FR_NOM_D''USAGE') ||' '||l_last_name||' '||l_first_name;

2526:
2527: IF l_last_name = l_maiden_name THEN
2528: l_formatted_name := l_last_name||' '||l_first_name;
2529: ELSE
2530: l_formatted_name := l_maiden_name||' '||hr_general.decode_lookup('NAME_TRANSLATIONS','FR_NOM_D''USAGE') ||' '||l_last_name||' '||l_first_name;
2531: END IF;
2532:
2533: END IF;
2534: END IF;