APPS.PAY_MX_FF_UDFS dependencies on HR_LOOKUPS

Line 291: FROM hr_lookups lkp

287: hr_utility.trace(' p_freq = '||p_freq);
288:
289: SELECT lookup_code
290: INTO v_pay_basis
291: FROM hr_lookups lkp
292: WHERE lkp.application_id = 800
293: AND lkp.lookup_type = 'PAY_BASIS'
294: AND lkp.meaning = p_freq;
295:

Line 1001: hr_lookups hrl

997: from pay_element_types_f pet,
998: pay_input_values_f piv,
999: pay_element_entries_f pee,
1000: pay_element_entry_values_f pev,
1001: hr_lookups hrl
1002: where pet.element_name='Integrated Daily Wage'
1003: and piv.element_type_id = pet.element_type_id
1004: and piv.name ='IDW Factor Table'
1005: and pee.element_type_id = pet.element_type_id

Line 1053: lv_basepay_rate_name hr_lookups.meaning%TYPE;

1049: ld_seniority_from DATE ;
1050: ln_seniority_years NUMBER;
1051: ln_idw_factor NUMBER;
1052: ln_basepay_rate NUMBER;
1053: lv_basepay_rate_name hr_lookups.meaning%TYPE;
1054: lv_fixedidw_rate_name hr_lookups.meaning%TYPE;
1055:
1056: FUNCTION get_fixed_idw (p_asg_id per_all_assignments_f.assignment_id%TYPE,
1057: p_calculation_date DATE,

Line 1054: lv_fixedidw_rate_name hr_lookups.meaning%TYPE;

1050: ln_seniority_years NUMBER;
1051: ln_idw_factor NUMBER;
1052: ln_basepay_rate NUMBER;
1053: lv_basepay_rate_name hr_lookups.meaning%TYPE;
1054: lv_fixedidw_rate_name hr_lookups.meaning%TYPE;
1055:
1056: FUNCTION get_fixed_idw (p_asg_id per_all_assignments_f.assignment_id%TYPE,
1057: p_calculation_date DATE,
1058: p_name VARCHAR2,

Line 1368: FROM hr_lookups

1364: * Cursor to get Rate Name based on Code
1365: */
1366: CURSOR c_get_rate_name(cp_lookup_code VARCHAR2) IS
1367: SELECT meaning
1368: FROM hr_lookups
1369: WHERE lookup_type = 'PQP_RATE_TYPE'
1370: AND lookup_code = cp_lookup_code;
1371:
1372: lv_rate_name VARCHAR2(240);