APPS.PER_UTILITY_FUNCTIONS dependencies on PAY_EVENT_GROUPS

Line 1157: from pay_event_groups e

1153: select e.event_group_id,
1154: e.event_group_name,
1155: e.business_group_id,
1156: e.legislation_code
1157: from pay_event_groups e
1158: where e.event_group_name = p_event_name;
1159: --
1160: l_proc varchar2(80) := g_package||'cache_events';
1161: --

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

1219: /* ========================================================================
1220: Name : Get Event
1221: ========================================================================
1222: Purpose : Gets the event_group_id from a cached pl/sql table to prevent
1223: same table scans on pay_event_groups for each person in the
1224: payroll run.
1225: Returns : event_id if found, otherwise null.
1226: -----------------------------------------------------------------------*/
1227: function get_event(p_event_name in varchar2,

Line 1366: l_event_group_id pay_event_groups.event_group_id%TYPE;

1362: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
1363: l_proration_change_type pay_interpreter_pkg.t_proration_type_table_type;
1364: l_proration_type pay_interpreter_pkg.t_proration_type_table_type;
1365:
1366: l_event_group_id pay_event_groups.event_group_id%TYPE;
1367: l_legislation_code HR_ORGANIZATION_INFORMATION.org_information9%TYPE;
1368:
1369: BEGIN
1370: hr_utility.set_location('Entering: '||l_proc, 5);