APPS.PAY_SE_TAX_TABLE_UPLOAD dependencies on PER_BUSINESS_GROUPS

Line 32: FROM per_business_groups

28: IS
29: CURSOR csr_legislation_code
30: IS
31: SELECT legislation_code
32: FROM per_business_groups
33: WHERE business_group_id = p_business_group;
34:
35: l_proc CONSTANT VARCHAR2 (72) := g_package || '.MAIN';
36: l_errbuf VARCHAR2 (1000);

Line 39: legislation_code per_business_groups.legislation_code%TYPE;

35: l_proc CONSTANT VARCHAR2 (72) := g_package || '.MAIN';
36: l_errbuf VARCHAR2 (1000);
37: l_retcode NUMBER;
38: lr_legislation_code csr_legislation_code%ROWTYPE;
39: legislation_code per_business_groups.legislation_code%TYPE;
40: BEGIN
41: l_errbuf := ' ';
42: l_retcode := 0;
43:

Line 120: FROM per_business_groups

116: IS
117: CURSOR csr_legislation_code
118: IS
119: SELECT legislation_code
120: FROM per_business_groups
121: WHERE business_group_id = p_business_group;
122:
123: CURSOR csr_range_table_id (
124: p_legislation_code per_business_groups.legislation_code%TYPE

Line 124: p_legislation_code per_business_groups.legislation_code%TYPE

120: FROM per_business_groups
121: WHERE business_group_id = p_business_group;
122:
123: CURSOR csr_range_table_id (
124: p_legislation_code per_business_groups.legislation_code%TYPE
125: )
126: IS
127: SELECT range_table_id
128: ,object_version_number

Line 149: legislation_code per_business_groups.legislation_code%TYPE;

145: AND effective_end_date <=
146: TO_DATE (p_effective_end_date, 'YYYY/MM/DD HH24:MI:SS');
147:
148: lr_legislation_code csr_legislation_code%ROWTYPE;
149: legislation_code per_business_groups.legislation_code%TYPE;
150: BEGIN
151: --hr_utility.trace_on(null,'tax');
152: hr_utility.set_location ('Entering: Purge ', 10);
153: hr_utility.set_location ('p_business_group ' || p_business_group, 10);