APPS.PAY_INTERPRETER_PKG dependencies on PER_BUSINESS_GROUPS

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 3484: p_business_group_id IN per_business_groups.business_group_id%type,

3480: PROCEDURE extra_tests_dbt_df
3481: (
3482: p_element_entry_id IN pay_element_entries.element_entry_id%type,
3483: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type,
3484: p_business_group_id IN per_business_groups.business_group_id%type,
3485: p_assignment_id IN per_all_assignments_f.assignment_id%type,
3486: p_mode IN VARCHAR2,
3487: p_process IN VARCHAR2,
3488: p_process_mode IN VARCHAR2,

Line 3673: p_business_group_id IN per_business_groups.business_group_id%type,

3669: PROCEDURE extra_tests_dbt_u_e
3670: (
3671: p_element_entry_id IN pay_element_entries.element_entry_id%type,
3672: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type,
3673: p_business_group_id IN per_business_groups.business_group_id%type,
3674: p_assignment_id IN per_all_assignments_f.assignment_id%type,
3675: p_process_mode IN VARCHAR2,
3676: p_event_group_id IN pay_event_groups.event_group_id%type,
3677: p_start_date IN date,

Line 4224: p_business_group_id IN per_business_groups.business_group_id%type,

4220: PROCEDURE extra_tests_dyt_pkg_u
4221: (
4222: p_element_entry_id IN pay_element_entries.element_entry_id%type,
4223: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type,
4224: p_business_group_id IN per_business_groups.business_group_id%type,
4225: p_assignment_id IN per_all_assignments_f.assignment_id%type,
4226: p_process_mode IN VARCHAR2,
4227: p_event_group_id IN pay_event_groups.event_group_id%type,
4228: p_start_date IN date,

Line 5658: from per_business_groups_perf

5654: (g_bus_grp_id is not null and
5655: g_bus_grp_id <> p_business_group_id)) then
5656: select legislation_code
5657: into g_leg_code
5658: from per_business_groups_perf
5659: where business_group_id = p_business_group_id;
5660: --
5661: g_bus_grp_id := p_business_group_id;
5662: end if;