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 169: lookup_type hr_lookups.lookup_type%type;

165: -- max_effend date;
166: val_date date;
167: asgno per_all_assignments_f.assignment_number%type;
168: link_id number;
169: lookup_type hr_lookups.lookup_type%type;
170: -- Bugfix 2827092
171: --value_set_id pay_input_values_f.value_set_id%type;
172: uom pay_input_values_f.uom%type;
173: input_curr pay_element_types_f.input_currency_code%type;

Line 2735: from hr_lookups hrl1

2731: from pay_element_entry_values_f ev3,
2732: pay_input_values_f iv3
2733: where TRANSLATE(UPPER(iv3.name), ' ', '_') =
2734: (select TRANSLATE(UPPER(hrl1.meaning), ' ', '_')
2735: from hr_lookups hrl1
2736: WHERE hrl1.lookup_type = 'NAME_TRANSLATIONS'
2737: AND hrl1.lookup_code = 'ADV_OVERRIDE')
2738: and l_eeid = ev3.element_entry_id
2739: and ev3.input_value_id = iv3.input_value_id

Line 2752: from hr_lookups hrl2

2748: from pay_element_entry_values_f ev4,
2749: pay_input_values_f iv4
2750: where TRANSLATE(UPPER(iv4.name), ' ', '_') =
2751: (select TRANSLATE(UPPER(hrl2.meaning), ' ', '_')
2752: from hr_lookups hrl2
2753: WHERE hrl2.lookup_type = 'NAME_TRANSLATIONS'
2754: AND hrl2.lookup_code = 'ADV_OVERRIDE')
2755: and l_eeid = ev4.element_entry_id
2756: and ev4.input_value_id = iv4.input_value_id

Line 3103: from hr_lookups pay_hrl3

3099: and pay_piv2.input_value_id = pay_pev2.input_value_id
3100: and hr_dynsql.adv_override_check(pay_pee.element_entry_id,pay_pac.effective_date,pay_pac.end_date) = ''Y''
3101: and TRANSLATE(UPPER(pay_piv.name), '' '', ''_'') =
3102: (select TRANSLATE(UPPER(pay_hrl3.meaning), '' '', ''_'')
3103: from hr_lookups pay_hrl3
3104: WHERE pay_hrl3.lookup_type = ''NAME_TRANSLATIONS''
3105: AND pay_hrl3.lookup_code = ''START_DATE'')
3106: and TRANSLATE(UPPER(pay_piv2.name), '' '', ''_'') =
3107: (select TRANSLATE(UPPER(pay_hrl4.meaning), '' '', ''_'')

Line 3108: from hr_lookups pay_hrl4

3104: WHERE pay_hrl3.lookup_type = ''NAME_TRANSLATIONS''
3105: AND pay_hrl3.lookup_code = ''START_DATE'')
3106: and TRANSLATE(UPPER(pay_piv2.name), '' '', ''_'') =
3107: (select TRANSLATE(UPPER(pay_hrl4.meaning), '' '', ''_'')
3108: from hr_lookups pay_hrl4
3109: WHERE pay_hrl4.lookup_type = ''NAME_TRANSLATIONS''
3110: AND pay_hrl4.lookup_code = ''END_DATE'')
3111: and (pay_pev.screen_entry_value between
3112: fnd_date.date_to_canonical(pay_pac.effective_date) and

Line 3153: from hr_lookups pay_hrl3

3149: and pay_piv2.input_value_id = pay_pev2.input_value_id
3150: and hr_dynsql.adv_override_check(pay_pee.element_entry_id,pay_pac.effective_date,pay_pac.end_date) = ''Y''
3151: and TRANSLATE(UPPER(pay_piv.name), '' '', ''_'') =
3152: (select TRANSLATE(UPPER(pay_hrl3.meaning), '' '', ''_'')
3153: from hr_lookups pay_hrl3
3154: WHERE pay_hrl3.lookup_type = ''NAME_TRANSLATIONS''
3155: AND pay_hrl3.lookup_code = ''START_DATE'')
3156: and TRANSLATE(UPPER(pay_piv2.name), '' '', ''_'') =
3157: (select TRANSLATE(UPPER(pay_hrl4.meaning), '' '', ''_'')

Line 3158: from hr_lookups pay_hrl4

3154: WHERE pay_hrl3.lookup_type = ''NAME_TRANSLATIONS''
3155: AND pay_hrl3.lookup_code = ''START_DATE'')
3156: and TRANSLATE(UPPER(pay_piv2.name), '' '', ''_'') =
3157: (select TRANSLATE(UPPER(pay_hrl4.meaning), '' '', ''_'')
3158: from hr_lookups pay_hrl4
3159: WHERE pay_hrl4.lookup_type = ''NAME_TRANSLATIONS''
3160: AND pay_hrl4.lookup_code = ''END_DATE'')
3161: and (pay_pev.screen_entry_value between
3162: fnd_date.date_to_canonical(pay_pac.effective_date) and