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 168: pay_element_links_f eli,

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

Line 767: l_element_link_id pay_element_links_f.element_link_id%type;

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