APPS.PAY_LOADER_UTILS_PKG dependencies on PAY_ELEMENT_SETS

Line 196: from pay_element_sets els

192: RETURN number IS
193: --
194: cursor csr_eset_id is
195: select element_set_id
196: from pay_element_sets els
197: where els.element_set_name = p_element_set_name
198: and nvl(els.legislation_code,hr_api.g_varchar2) = nvl(p_legislation_code,hr_api.g_varchar2)
199: and nvl(els.business_group_id,hr_api.g_number) = nvl(p_business_group_id,hr_api.g_number);
200: --

Line 202: l_element_set_id pay_element_sets.element_set_id%type;

198: and nvl(els.legislation_code,hr_api.g_varchar2) = nvl(p_legislation_code,hr_api.g_varchar2)
199: and nvl(els.business_group_id,hr_api.g_number) = nvl(p_business_group_id,hr_api.g_number);
200: --
201: l_proc varchar2(72) := g_package||'get_element_set_id';
202: l_element_set_id pay_element_sets.element_set_id%type;
203: --
204: BEGIN
205: --
206:

Line 1102: l_element_set_id pay_element_sets.element_set_id%type;

1098: --
1099: l_proc varchar2(72) := g_package||'load_egu_row';
1100: l_exists varchar2 (1);
1101: l_event_group_id pay_event_groups.event_group_id%type;
1102: l_element_set_id pay_element_sets.element_set_id%type;
1103: l_business_group_id pay_event_group_usages.business_group_id%type;
1104: l_legislation_code pay_event_group_usages.legislation_code%type;
1105: l_evg_bus_group_id pay_event_groups.business_group_id%type;
1106: l_els_bus_group_id pay_element_sets.business_group_id%type;

Line 1106: l_els_bus_group_id pay_element_sets.business_group_id%type;

1102: l_element_set_id pay_element_sets.element_set_id%type;
1103: l_business_group_id pay_event_group_usages.business_group_id%type;
1104: l_legislation_code pay_event_group_usages.legislation_code%type;
1105: l_evg_bus_group_id pay_event_groups.business_group_id%type;
1106: l_els_bus_group_id pay_element_sets.business_group_id%type;
1107: l_event_group_usage_id pay_event_group_usages.event_group_usage_id%type;
1108: l_ovn pay_event_group_usages.object_version_number%type;
1109: --
1110: cursor csr_exists is