eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DYNSQL dependencies on HR_LOOKUPS

Line 164: lookup_type hr_lookups.lookup_type%type;

160: -- max_effend date;
161: val_date date;
162: asgno per_all_assignments_f.assignment_number%type;
163: link_id number;
164: lookup_type hr_lookups.lookup_type%type;
165: -- Bugfix 2827092
166: --value_set_id pay_input_values_f.value_set_id%type;
167: uom pay_input_values_f.uom%type;
168: input_curr pay_element_types_f.input_currency_code%type;

Line 2677: from hr_lookups hrl1

2673: from pay_element_entry_values_f ev3,
2674: pay_input_values_f iv3
2675: where TRANSLATE(UPPER(iv3.name), ' ', '_') =
2676: (select TRANSLATE(UPPER(hrl1.meaning), ' ', '_')
2677: from hr_lookups hrl1
2678: WHERE hrl1.lookup_type = 'NAME_TRANSLATIONS'
2679: AND hrl1.lookup_code = 'ADV_OVERRIDE')
2680: and l_eeid = ev3.element_entry_id
2681: and ev3.input_value_id = iv3.input_value_id

Line 2694: from hr_lookups hrl2

2690: from pay_element_entry_values_f ev4,
2691: pay_input_values_f iv4
2692: where TRANSLATE(UPPER(iv4.name), ' ', '_') =
2693: (select TRANSLATE(UPPER(hrl2.meaning), ' ', '_')
2694: from hr_lookups hrl2
2695: WHERE hrl2.lookup_type = 'NAME_TRANSLATIONS'
2696: AND hrl2.lookup_code = 'ADV_OVERRIDE')
2697: and l_eeid = ev4.element_entry_id
2698: and ev4.input_value_id = iv4.input_value_id

Line 3025: from hr_lookups pay_hrl3

3021: and pay_piv2.input_value_id = pay_pev2.input_value_id
3022: and hr_dynsql.adv_override_check(pay_pee.element_entry_id,pay_pac.effective_date,pay_pac.end_date) = ''Y''
3023: and TRANSLATE(UPPER(pay_piv.name), '' '', ''_'') =
3024: (select TRANSLATE(UPPER(pay_hrl3.meaning), '' '', ''_'')
3025: from hr_lookups pay_hrl3
3026: WHERE pay_hrl3.lookup_type = ''NAME_TRANSLATIONS''
3027: AND pay_hrl3.lookup_code = ''START_DATE'')
3028: and TRANSLATE(UPPER(pay_piv2.name), '' '', ''_'') =
3029: (select TRANSLATE(UPPER(pay_hrl4.meaning), '' '', ''_'')

Line 3030: from hr_lookups pay_hrl4

3026: WHERE pay_hrl3.lookup_type = ''NAME_TRANSLATIONS''
3027: AND pay_hrl3.lookup_code = ''START_DATE'')
3028: and TRANSLATE(UPPER(pay_piv2.name), '' '', ''_'') =
3029: (select TRANSLATE(UPPER(pay_hrl4.meaning), '' '', ''_'')
3030: from hr_lookups pay_hrl4
3031: WHERE pay_hrl4.lookup_type = ''NAME_TRANSLATIONS''
3032: AND pay_hrl4.lookup_code = ''END_DATE'')
3033: and (pay_pev.screen_entry_value between
3034: fnd_date.date_to_canonical(pay_pac.effective_date) and

Line 3075: from hr_lookups pay_hrl3

3071: and pay_piv2.input_value_id = pay_pev2.input_value_id
3072: and hr_dynsql.adv_override_check(pay_pee.element_entry_id,pay_pac.effective_date,pay_pac.end_date) = ''Y''
3073: and TRANSLATE(UPPER(pay_piv.name), '' '', ''_'') =
3074: (select TRANSLATE(UPPER(pay_hrl3.meaning), '' '', ''_'')
3075: from hr_lookups pay_hrl3
3076: WHERE pay_hrl3.lookup_type = ''NAME_TRANSLATIONS''
3077: AND pay_hrl3.lookup_code = ''START_DATE'')
3078: and TRANSLATE(UPPER(pay_piv2.name), '' '', ''_'') =
3079: (select TRANSLATE(UPPER(pay_hrl4.meaning), '' '', ''_'')

Line 3080: from hr_lookups pay_hrl4

3076: WHERE pay_hrl3.lookup_type = ''NAME_TRANSLATIONS''
3077: AND pay_hrl3.lookup_code = ''START_DATE'')
3078: and TRANSLATE(UPPER(pay_piv2.name), '' '', ''_'') =
3079: (select TRANSLATE(UPPER(pay_hrl4.meaning), '' '', ''_'')
3080: from hr_lookups pay_hrl4
3081: WHERE pay_hrl4.lookup_type = ''NAME_TRANSLATIONS''
3082: AND pay_hrl4.lookup_code = ''END_DATE'')
3083: and (pay_pev.screen_entry_value between
3084: fnd_date.date_to_canonical(pay_pac.effective_date) and