APPS.PAY_JP_FORMULA_FUNCTION_PKG dependencies on PER_BUSINESS_GROUPS

Line 37: l_legislation_code per_business_groups.legislation_code%type;

33: l_effective_date date;
34: l_range_or_match pay_user_tables.range_or_match%type;
35: l_user_table_id pay_user_tables.user_table_id%type;
36: l_value pay_user_column_instances_f.value%type;
37: l_legislation_code per_business_groups.legislation_code%type;
38: --
39: cursor csr_value_match
40: is
41: select puci.value

Line 112: from per_business_groups

108: --
109: /* Get the legislation code */
110: select legislation_code
111: into l_legislation_code
112: from per_business_groups
113: where business_group_id = p_business_group_id;
114: --
115: /* Get the type of query to be performed, either range or match */
116: select range_or_match,

Line 337: from per_business_groups_perf

333: g_business_group_id := p_business_group_id;
334: --
335: select legislation_code
336: into g_legislation_code
337: from per_business_groups_perf
338: where business_group_id = g_business_group_id;
339: --
340: end if;
341: --