DBA Data[Home] [Help]

APPS.PAY_FR_DUCS dependencies on HR_GENERAL

Line 122: p_french_base := hr_general.decode_lookup('NAME_TRANSLATIONS','BASE');

118: p_english_rate := 'Rate';
119: p_english_pay_value := 'Pay Value';
120: p_english_contrib_code := 'Contribution_Code';
121: --
122: p_french_base := hr_general.decode_lookup('NAME_TRANSLATIONS','BASE');
123: p_french_rate := hr_general.decode_lookup('NAME_TRANSLATIONS','RATE');
124: p_french_pay_value :=
125: hr_general.decode_lookup('NAME_TRANSLATIONS','PAY VALUE');
126: p_french_contrib_code :=

Line 123: p_french_rate := hr_general.decode_lookup('NAME_TRANSLATIONS','RATE');

119: p_english_pay_value := 'Pay Value';
120: p_english_contrib_code := 'Contribution_Code';
121: --
122: p_french_base := hr_general.decode_lookup('NAME_TRANSLATIONS','BASE');
123: p_french_rate := hr_general.decode_lookup('NAME_TRANSLATIONS','RATE');
124: p_french_pay_value :=
125: hr_general.decode_lookup('NAME_TRANSLATIONS','PAY VALUE');
126: p_french_contrib_code :=
127: hr_general.decode_lookup('NAME_TRANSLATIONS','CONTRIBUTION CODE');

Line 125: hr_general.decode_lookup('NAME_TRANSLATIONS','PAY VALUE');

121: --
122: p_french_base := hr_general.decode_lookup('NAME_TRANSLATIONS','BASE');
123: p_french_rate := hr_general.decode_lookup('NAME_TRANSLATIONS','RATE');
124: p_french_pay_value :=
125: hr_general.decode_lookup('NAME_TRANSLATIONS','PAY VALUE');
126: p_french_contrib_code :=
127: hr_general.decode_lookup('NAME_TRANSLATIONS','CONTRIBUTION CODE');
128:
129:

Line 127: hr_general.decode_lookup('NAME_TRANSLATIONS','CONTRIBUTION CODE');

123: p_french_rate := hr_general.decode_lookup('NAME_TRANSLATIONS','RATE');
124: p_french_pay_value :=
125: hr_general.decode_lookup('NAME_TRANSLATIONS','PAY VALUE');
126: p_french_contrib_code :=
127: hr_general.decode_lookup('NAME_TRANSLATIONS','CONTRIBUTION CODE');
128:
129:
130: hr_utility.set_location('Leaving ' || l_proc, 100);
131:

Line 1280: l_contribution_text := hr_general.decode_lookup('FR_URSSAF_CONTRI_CODE'

1276:
1277: -- Get Contribution Text
1278: IF rec_contr.contribution_type = 'URSSAF' THEN
1279: -- Last 4 chars of contribution code define the text
1280: l_contribution_text := hr_general.decode_lookup('FR_URSSAF_CONTRI_CODE'
1281: ,substr(rec_contr.contribution_code,4,4));
1282:
1283: ELSIF rec_contr.contribution_type = 'ASSEDIC' THEN -- ASSEDIC
1284: -- Last 3 chars of contribution code define the text

Line 1359: l_pension_code := hr_general.decode_lookup('FR_USER_PENSION_CONTRIB_CODE'

1355: ,l_tag);
1356: l_tag:=replace(l_tag,'N/C','NON CADRES');
1357:
1358: -- if the code exists in FR_USER_PENSION_CODE first
1359: l_pension_code := hr_general.decode_lookup('FR_USER_PENSION_CONTRIB_CODE'
1360: ,substr(rec_contr.contribution_code,6,2));
1361:
1362: -- If user code is null then use
1363: IF l_pension_code IS NULL THEN

Line 1364: l_pension_code := hr_general.decode_lookup('FR_PENSION_CONTRI_CODE'

1360: ,substr(rec_contr.contribution_code,6,2));
1361:
1362: -- If user code is null then use
1363: IF l_pension_code IS NULL THEN
1364: l_pension_code := hr_general.decode_lookup('FR_PENSION_CONTRI_CODE'
1365: ,substr(rec_contr.contribution_code,6,2));
1366: END IF;
1367:
1368:

Line 1773: l_period_description := l_quarter||' '|| hr_general.decode_lookup('PROC_PERIOD_TYPE','Q')||' '||l_year;

1769: l_period_code := substr(l_year,3,2)||l_quarter||l_miq;
1770:
1771: ELSE
1772: l_date_from := '01/'||to_char(add_months(g_effective_date,-2), 'MM/YYYY');
1773: l_period_description := l_quarter||' '|| hr_general.decode_lookup('PROC_PERIOD_TYPE','Q')||' '||l_year;
1774: l_period_code := substr(l_year,3,2)||l_quarter||'0';
1775: END IF;
1776:
1777: l_currency := 'euro';