APPS.PAY_INTERPRETER_PKG dependencies on PER_BUSINESS_GROUPS_PERF

Line 11: g_leg_code per_business_groups_perf.legislation_code%TYPE;

7: g_dbg BOOLEAN := FALSE; --Used for diagnosing issues by dev, more outputs
8:
9: -- Global caches
10: g_business_group_id NUMBER; -- business_group_id cache
11: g_leg_code per_business_groups_perf.legislation_code%TYPE;
12: g_bus_grp_id per_business_groups_perf.business_group_id%TYPE;
13: g_key_date_cache t_key_date_cache; -- store of min dates for ins records
14: TYPE t_upd_cache is
15: table of varchar2(240) INDEX BY BINARY_INTEGER;

Line 12: g_bus_grp_id per_business_groups_perf.business_group_id%TYPE;

8:
9: -- Global caches
10: g_business_group_id NUMBER; -- business_group_id cache
11: g_leg_code per_business_groups_perf.legislation_code%TYPE;
12: g_bus_grp_id per_business_groups_perf.business_group_id%TYPE;
13: g_key_date_cache t_key_date_cache; -- store of min dates for ins records
14: TYPE t_upd_cache is
15: table of varchar2(240) INDEX BY BINARY_INTEGER;
16: g_upd_cache t_upd_cache; -- store of min dates for ins records

Line 171: per_business_groups_perf pbg

167: SELECT pbg.legislation_code legislation_code,
168: pbg.business_group_id business_group_id
169: FROM pay_assignment_actions paa,
170: pay_payroll_actions ppa,
171: per_business_groups_perf pbg
172: WHERE paa.assignment_action_id = p_assignment_action_id
173: AND paa.payroll_action_id = ppa.payroll_action_id
174: AND ppa.business_group_id = pbg.business_group_id ;
175: --

Line 969: per_business_groups_perf pbg

965: p_column_name IN VARCHAR2 ,
966: p_bg_id IN NUMBER) IS
967: SELECT pep.procedure_name
968: FROM pay_event_procedures pep,
969: per_business_groups_perf pbg
970: WHERE pep.dated_table_id = p_table_id
971: AND UPPER(pep.column_name) = UPPER(p_column_name)
972: AND nvl(pep.procedure_type, 'E') = 'E'
973: AND pbg.business_group_id = p_bg_id

Line 5403: from per_business_groups_perf

5399: (g_bus_grp_id is not null and
5400: g_bus_grp_id <> p_business_group_id)) then
5401: select legislation_code
5402: into g_leg_code
5403: from per_business_groups_perf
5404: where business_group_id = p_business_group_id;
5405: --
5406: g_bus_grp_id := p_business_group_id;
5407: end if;