APPS.PAY_MX_FF_UDFS dependencies on HR_LOOKUPS

Line 304: FROM hr_lookups lkp

300: hr_utility.trace(' p_freq = '||p_freq);
301:
302: SELECT lookup_code
303: INTO v_pay_basis
304: FROM hr_lookups lkp
305: WHERE lkp.application_id = 800
306: AND lkp.lookup_type = 'PAY_BASIS'
307: AND lkp.meaning = p_freq;
308:

Line 1153: hr_lookups hrl

1149: from pay_element_types_f pet,
1150: pay_input_values_f piv,
1151: pay_element_entries_f pee,
1152: pay_element_entry_values_f pev,
1153: hr_lookups hrl
1154: where pet.element_name='Integrated Daily Wage'
1155: and piv.element_type_id = pet.element_type_id
1156: and piv.name ='IDW Factor Table'
1157: and pee.element_type_id = pet.element_type_id

Line 1205: lv_basepay_rate_name hr_lookups.meaning%TYPE;

1201: ld_seniority_from DATE ;
1202: ln_seniority_years NUMBER;
1203: ln_idw_factor NUMBER;
1204: ln_basepay_rate NUMBER;
1205: lv_basepay_rate_name hr_lookups.meaning%TYPE;
1206: lv_fixedidw_rate_name hr_lookups.meaning%TYPE;
1207:
1208: FUNCTION get_fixed_idw (p_asg_id per_all_assignments_f.assignment_id%TYPE,
1209: p_calculation_date DATE,

Line 1206: lv_fixedidw_rate_name hr_lookups.meaning%TYPE;

1202: ln_seniority_years NUMBER;
1203: ln_idw_factor NUMBER;
1204: ln_basepay_rate NUMBER;
1205: lv_basepay_rate_name hr_lookups.meaning%TYPE;
1206: lv_fixedidw_rate_name hr_lookups.meaning%TYPE;
1207:
1208: FUNCTION get_fixed_idw (p_asg_id per_all_assignments_f.assignment_id%TYPE,
1209: p_calculation_date DATE,
1210: p_name VARCHAR2,

Line 1523: FROM hr_lookups

1519: * Cursor to get Rate Name based on Code
1520: */
1521: CURSOR c_get_rate_name(cp_lookup_code VARCHAR2) IS
1522: SELECT meaning
1523: FROM hr_lookups
1524: WHERE lookup_type = 'PQP_RATE_TYPE'
1525: AND lookup_code = cp_lookup_code;
1526:
1527: lv_rate_name VARCHAR2(240);