DBA Data[Home] [Help]

APPS.GHR_ELEMENT_API dependencies on PAY_ELEMENT_LINKS_F

Line 57: ,p_element_link_id out nocopy pay_element_links_f.element_link_id%type

53: ,p_input_value_name in pay_input_values_f.name%type
54: ,p_assignment_id in pay_element_entries_f.assignment_id%type
55: ,p_effective_date in date
56: ,p_processing_type in pay_element_types_f.processing_type%type
57: ,p_element_link_id out nocopy pay_element_links_f.element_link_id%type
58: ,p_input_value_id out nocopy pay_input_values_f.input_value_id%type
59: ,p_element_entry_id out nocopy pay_element_entries_f.element_entry_id%type
60: ,p_value out nocopy pay_element_entry_values_f.screen_entry_value%type
61: ,p_object_version_number

Line 87: pay_element_links_f eli,

83: eev.screen_entry_value screen_entry_value,
84: ele.object_version_number
85: from pay_element_types_f elt,
86: pay_input_values_f ipv,
87: pay_element_links_f eli,
88: pay_element_entries_f ele,
89: pay_element_entry_values_f eev
90: where trunc(eff_date) between elt.effective_start_date
91: and elt.effective_end_date

Line 125: pay_element_links_f eli,

121: eev.screen_entry_value screen_entry_value,
122: ele.object_version_number
123: from pay_element_types_f elt,
124: pay_input_values_f ipv,
125: pay_element_links_f eli,
126: pay_element_entries_f ele,
127: pay_element_entry_values_f eev
128: where trunc(eff_date) between elt.effective_start_date
129: and elt.effective_end_date

Line 170: pay_element_links_f eli,

166: eev.screen_entry_value screen_entry_value,
167: ele.object_version_number
168: from pay_element_types_f elt,
169: pay_input_values_f ipv,
170: pay_element_links_f eli,
171: pay_element_entries_f ele,
172: pay_element_entry_values_f eev
173: where trunc(eff_date) between elt.effective_start_date
174: and elt.effective_end_date

Line 769: l_element_link_id pay_element_links_f.element_link_id%type;

765: --
766: l_proc varchar2(72) := g_package||'process_sf52_element';
767: l_business_group_id per_business_groups.business_group_id%type;
768: l_element_type_id pay_element_types_f.element_type_id%type;
769: l_element_link_id pay_element_links_f.element_link_id%type;
770: l_entry_type pay_element_entries_f.entry_type%type default 'E';
771: l_input_value_id1 pay_input_values_f.input_value_id%type;
772: l_input_value_id2 pay_input_values_f.input_value_id%type;
773: l_input_value_id3 pay_input_values_f.input_value_id%type;