APPS.PER_UTILITY_FUNCTIONS dependencies on PAY_EVENT_GROUPS

Line 1253: from pay_event_groups e

1249: select e.event_group_id,
1250: e.event_group_name,
1251: e.business_group_id,
1252: e.legislation_code
1253: from pay_event_groups e
1254: where e.event_group_name = p_event_name;
1255: --
1256: l_proc varchar2(80) := g_package||'cache_events';
1257: --

Line 1319: same table scans on pay_event_groups for each person in the

1315: /* ========================================================================
1316: Name : Get Event
1317: ========================================================================
1318: Purpose : Gets the event_group_id from a cached pl/sql table to prevent
1319: same table scans on pay_event_groups for each person in the
1320: payroll run.
1321: Returns : event_id if found, otherwise null.
1322: -----------------------------------------------------------------------*/
1323: function get_event(p_event_name in varchar2,

Line 1462: l_event_group_id pay_event_groups.event_group_id%TYPE;

1458: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
1459: l_proration_change_type pay_interpreter_pkg.t_proration_type_table_type;
1460: l_proration_type pay_interpreter_pkg.t_proration_type_table_type;
1461:
1462: l_event_group_id pay_event_groups.event_group_id%TYPE;
1463: l_legislation_code HR_ORGANIZATION_INFORMATION.org_information9%TYPE;
1464:
1465: BEGIN
1466: hr_utility.set_location('Entering: '||l_proc, 5);