APPS.HR_DYNSQL dependencies on PAY_INPUT_VALUES_F

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

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

Line 167: uom pay_input_values_f.uom%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;
169: screen_value pay_element_entry_values_f.screen_entry_value%type;
170: db_value pay_element_entry_values_f.screen_entry_value%type;
171: old_value pay_element_entry_values_f.screen_entry_value%type;

Line 211: pay_input_values_f piv,

207: input_curr
208: from pay_element_entries_f pee,
209: pay_element_links_f pel,
210: pay_element_types_f pet,
211: pay_input_values_f piv,
212: per_all_assignments_f asg
213: where asg.assignment_id = p_assignment_id
214: and p_effective_date between
215: asg.effective_start_date and asg.effective_end_date

Line 2674: pay_input_values_f iv3

2670: from dual
2671: where (NOT EXISTS
2672: (select null
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'

Line 2691: pay_input_values_f iv4

2687: and iv3.effective_end_date > l_start_date )))
2688: OR EXISTS
2689: (select null
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'

Line 2953: pay_input_values_f p_piv,

2949: and exists (select null from
2950: pay_element_entries_f p_pee,
2951: pay_element_entry_values_f p_pev,
2952: pay_element_entry_values_f p_pev2,
2953: pay_input_values_f p_piv,
2954: pay_input_values_f p_piv2
2955: where p_pee.assignment_id = pay_asg.assignment_id
2956: and pay_pac.effective_date between p_pee.effective_start_date
2957: and p_pee.effective_end_date

Line 2954: pay_input_values_f p_piv2

2950: pay_element_entries_f p_pee,
2951: pay_element_entry_values_f p_pev,
2952: pay_element_entry_values_f p_pev2,
2953: pay_input_values_f p_piv,
2954: pay_input_values_f p_piv2
2955: where p_pee.assignment_id = pay_asg.assignment_id
2956: and pay_pac.effective_date between p_pee.effective_start_date
2957: and p_pee.effective_end_date
2958: and p_pee.element_type_id =

Line 3013: pay_input_values_f pay_piv,

3009: from pay_element_entries_f pay_pee,
3010: pay_element_types_f pay_pet,
3011: pay_element_entry_values_f pay_pev,
3012: pay_element_entry_values_f pay_pev2,
3013: pay_input_values_f pay_piv,
3014: pay_input_values_f pay_piv2
3015: where pay_pee.assignment_id = pay_asg.assignment_id
3016: and pay_pee.element_type_id = pay_pet.element_type_id
3017: and pay_pet.advance_indicator = ''Y''

Line 3014: pay_input_values_f pay_piv2

3010: pay_element_types_f pay_pet,
3011: pay_element_entry_values_f pay_pev,
3012: pay_element_entry_values_f pay_pev2,
3013: pay_input_values_f pay_piv,
3014: pay_input_values_f pay_piv2
3015: where pay_pee.assignment_id = pay_asg.assignment_id
3016: and pay_pee.element_type_id = pay_pet.element_type_id
3017: and pay_pet.advance_indicator = ''Y''
3018: and pay_pee.element_entry_id = pay_pev.element_entry_id

Line 3063: pay_input_values_f pay_piv,

3059: from pay_element_entries_f pay_pee,
3060: pay_element_types_f pay_pet,
3061: pay_element_entry_values_f pay_pev,
3062: pay_element_entry_values_f pay_pev2,
3063: pay_input_values_f pay_piv,
3064: pay_input_values_f pay_piv2
3065: where pay_pee.assignment_id = pay_asg.assignment_id
3066: and pay_pee.element_type_id = pay_pet.element_type_id
3067: and pay_pet.advance_indicator = ''Y''

Line 3064: pay_input_values_f pay_piv2

3060: pay_element_types_f pay_pet,
3061: pay_element_entry_values_f pay_pev,
3062: pay_element_entry_values_f pay_pev2,
3063: pay_input_values_f pay_piv,
3064: pay_input_values_f pay_piv2
3065: where pay_pee.assignment_id = pay_asg.assignment_id
3066: and pay_pee.element_type_id = pay_pet.element_type_id
3067: and pay_pet.advance_indicator = ''Y''
3068: and pay_pee.element_entry_id = pay_pev.element_entry_id