APPS.HR_DYNSQL dependencies on PAY_INPUT_VALUES_F

Line 171: --value_set_id pay_input_values_f.value_set_id%type;

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;
174: screen_value pay_element_entry_values_f.screen_entry_value%type;
175: db_value pay_element_entry_values_f.screen_entry_value%type;

Line 172: uom pay_input_values_f.uom%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;
174: screen_value pay_element_entry_values_f.screen_entry_value%type;
175: db_value pay_element_entry_values_f.screen_entry_value%type;
176: old_value pay_element_entry_values_f.screen_entry_value%type;

Line 216: pay_input_values_f piv,

212: input_curr
213: from pay_element_entries_f pee,
214: pay_element_links_f pel,
215: pay_element_types_f pet,
216: pay_input_values_f piv,
217: per_all_assignments_f asg
218: where asg.assignment_id = p_assignment_id
219: and p_effective_date between
220: asg.effective_start_date and asg.effective_end_date

Line 2732: pay_input_values_f iv3

2728: from dual
2729: where (NOT EXISTS
2730: (select null
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'

Line 2749: pay_input_values_f iv4

2745: and iv3.effective_end_date > l_start_date )))
2746: OR EXISTS
2747: (select null
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'

Line 3031: pay_input_values_f p_piv,

3027: and exists (select null from
3028: pay_element_entries_f p_pee,
3029: pay_element_entry_values_f p_pev,
3030: pay_element_entry_values_f p_pev2,
3031: pay_input_values_f p_piv,
3032: pay_input_values_f p_piv2
3033: where p_pee.assignment_id = pay_asg.assignment_id
3034: and pay_pac.effective_date between p_pee.effective_start_date
3035: and p_pee.effective_end_date

Line 3032: pay_input_values_f p_piv2

3028: pay_element_entries_f p_pee,
3029: pay_element_entry_values_f p_pev,
3030: pay_element_entry_values_f p_pev2,
3031: pay_input_values_f p_piv,
3032: pay_input_values_f p_piv2
3033: where p_pee.assignment_id = pay_asg.assignment_id
3034: and pay_pac.effective_date between p_pee.effective_start_date
3035: and p_pee.effective_end_date
3036: and p_pee.element_type_id =

Line 3091: pay_input_values_f pay_piv,

3087: from pay_element_entries_f pay_pee,
3088: pay_element_types_f pay_pet,
3089: pay_element_entry_values_f pay_pev,
3090: pay_element_entry_values_f pay_pev2,
3091: pay_input_values_f pay_piv,
3092: pay_input_values_f pay_piv2
3093: where pay_pee.assignment_id = pay_asg.assignment_id
3094: and pay_pee.element_type_id = pay_pet.element_type_id
3095: and pay_pet.advance_indicator = ''Y''

Line 3092: pay_input_values_f pay_piv2

3088: pay_element_types_f pay_pet,
3089: pay_element_entry_values_f pay_pev,
3090: pay_element_entry_values_f pay_pev2,
3091: pay_input_values_f pay_piv,
3092: pay_input_values_f pay_piv2
3093: where pay_pee.assignment_id = pay_asg.assignment_id
3094: and pay_pee.element_type_id = pay_pet.element_type_id
3095: and pay_pet.advance_indicator = ''Y''
3096: and pay_pee.element_entry_id = pay_pev.element_entry_id

Line 3141: pay_input_values_f pay_piv,

3137: from pay_element_entries_f pay_pee,
3138: pay_element_types_f pay_pet,
3139: pay_element_entry_values_f pay_pev,
3140: pay_element_entry_values_f pay_pev2,
3141: pay_input_values_f pay_piv,
3142: pay_input_values_f pay_piv2
3143: where pay_pee.assignment_id = pay_asg.assignment_id
3144: and pay_pee.element_type_id = pay_pet.element_type_id
3145: and pay_pet.advance_indicator = ''Y''

Line 3142: pay_input_values_f pay_piv2

3138: pay_element_types_f pay_pet,
3139: pay_element_entry_values_f pay_pev,
3140: pay_element_entry_values_f pay_pev2,
3141: pay_input_values_f pay_piv,
3142: pay_input_values_f pay_piv2
3143: where pay_pee.assignment_id = pay_asg.assignment_id
3144: and pay_pee.element_type_id = pay_pet.element_type_id
3145: and pay_pet.advance_indicator = ''Y''
3146: and pay_pee.element_entry_id = pay_pev.element_entry_id