APPS.PAY_LOADER_UTILS_PKG dependencies on PAY_EVENT_GROUPS

Line 151: from pay_event_groups evg

147: RETURN number IS
148: --
149: cursor csr_evg_grp_id is
150: select event_group_id
151: from pay_event_groups evg
152: where evg.event_group_name = p_event_group_name
153: and nvl(evg.legislation_code,hr_api.g_varchar2) = nvl(p_legislation_code,hr_api.g_varchar2)
154: and nvl(evg.business_group_id,hr_api.g_number) = nvl(p_business_group_id,hr_api.g_number);
155: --

Line 157: l_event_group_id pay_event_groups.event_group_id%type;

153: and nvl(evg.legislation_code,hr_api.g_varchar2) = nvl(p_legislation_code,hr_api.g_varchar2)
154: and nvl(evg.business_group_id,hr_api.g_number) = nvl(p_business_group_id,hr_api.g_number);
155: --
156: l_proc varchar2(72) := g_package||'get_event_group_id';
157: l_event_group_id pay_event_groups.event_group_id%type;
158: --
159: BEGIN
160: --
161:

Line 1101: l_event_group_id pay_event_groups.event_group_id%type;

1097: ,p_owner in varchar2 ) IS
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;

Line 1105: l_evg_bus_group_id pay_event_groups.business_group_id%type;

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;
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: --