DBA Data[Home] [Help]

APPS.PQP_GB_OSP_FUNCTIONS dependencies on HR_GENERAL

Line 2260: hr_general.decode_lookup

2256: --THEN
2257: i := i + 1;
2258: l_band_entitlements(i).band := 'BAND1';
2259: l_band_entitlements(i).meaning :=
2260: hr_general.decode_lookup
2261: (p_entitlement_bands_list_name
2262: ,l_band_entitlements(i).band);
2263: l_band_entitlements(i).entitlement := l_band_entitlement;
2264: --END IF;

Line 2273: hr_general.decode_lookup

2269: THEN
2270: i := i + 1;
2271: l_band_entitlements(i).band := 'BAND2';
2272: l_band_entitlements(i).meaning :=
2273: hr_general.decode_lookup
2274: (p_entitlement_bands_list_name
2275: ,l_band_entitlements(i).band);
2276: l_band_entitlements(i).entitlement := l_band_entitlement;
2277: END IF;

Line 2286: hr_general.decode_lookup

2282: THEN
2283: i := i + 1;
2284: l_band_entitlements(i).band := 'BAND3';
2285: l_band_entitlements(i).meaning :=
2286: hr_general.decode_lookup
2287: (p_entitlement_bands_list_name
2288: ,l_band_entitlements(i).band);
2289: l_band_entitlements(i).entitlement := l_band_entitlement;
2290: END IF;

Line 2299: hr_general.decode_lookup

2295: THEN
2296: i := i + 1;
2297: l_band_entitlements(i).band := 'BAND4';
2298: l_band_entitlements(i).meaning :=
2299: hr_general.decode_lookup
2300: (p_entitlement_bands_list_name
2301: ,l_band_entitlements(i).band);
2302: l_band_entitlements(i).entitlement := l_band_entitlement;
2303: END IF;

Line 2825: hr_general.decode_lookup(

2821: debug_exit(l_proc_name);
2822: RETURN -1;
2823: ELSE
2824: l_band_ent_rows.earnings_type :=
2825: hr_general.decode_lookup(
2826: p_lookup_type => 'PQP_GB_OMP_EARNINGS_TYPE'
2827: ,p_lookup_code => l_band_avg_rec_ind
2828: );
2829: END IF; -- IF l_band_avg_rec_ind IS NULL

Line 3590: hr_general.decode_lookup(

3586: IF p_column_name IS NULL
3587: THEN
3588: -- Get the Column from the Lookup
3589: l_column_name :=
3590: hr_general.decode_lookup(
3591: p_lookup_type => 'PQP_GB_OMP_CALENDAR_RULES'
3592: ,p_lookup_code => 'EXCLUDED'
3593: );
3594: ELSE

Line 3842: hr_general.decode_lookup(

3838: IF p_column_name IS NULL
3839: THEN
3840: -- Get the Column from the Lookup
3841: l_column_name :=
3842: hr_general.decode_lookup(
3843: p_lookup_type => 'PQP_GB_OMP_CALENDAR_RULES'
3844: ,p_lookup_code => 'EXCLUDED'
3845: );
3846: ELSE