APPS.PAY_NO_TAX_TABLE_UPLOAD dependencies on PER_BUSINESS_GROUPS

Line 33: select LEGISLATION_CODE from PER_BUSINESS_GROUPS where BUSINESS_GROUP_ID=p_business_group;

29: IS
30:
31: CURSOR CSR_Legislation_Code
32: is
33: select LEGISLATION_CODE from PER_BUSINESS_GROUPS where BUSINESS_GROUP_ID=p_business_group;
34:
35:
36: l_proc CONSTANT VARCHAR2 (72) := g_package||'.MAIN' ;
37: l_errbuf VARCHAR2 (1000);

Line 42: Legislation_Code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;

38: l_retcode Number;
39:
40: lr_Legislation_Code CSR_Legislation_Code%ROWTYPE;
41:
42: Legislation_Code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;
43:
44: BEGIN
45: --hr_utility.trace_on(null,'vsvn1');
46: OPEN CSR_Legislation_Code;

Line 104: select LEGISLATION_CODE from PER_BUSINESS_GROUPS where BUSINESS_GROUP_ID=p_business_group;

100: IS
101:
102: CURSOR csr_Legislation_Code
103: is
104: select LEGISLATION_CODE from PER_BUSINESS_GROUPS where BUSINESS_GROUP_ID=p_business_group;
105:
106:
107: /*
108:

Line 109: CURSOR csr_RANGE_TABLE_ID(p_Legislation_Code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)

105:
106:
107: /*
108:
109: CURSOR csr_RANGE_TABLE_ID(p_Legislation_Code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)
110: is
111: select RANGE_TABLE_ID ,OBJECT_VERSION_NUMBER
112: from PAY_RANGE_TABLES_F
113: where LEGISLATION_CODE = p_Legislation_Code

Line 123: CURSOR csr_RANGE_TABLE_ID(p_Legislation_Code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)

119:
120: -- Bug Fix 5533206, Norwegian Tax Tables will now be uploaded without any Business Group
121: -- modifying cursor to remove the check for business group id
122:
123: CURSOR csr_RANGE_TABLE_ID(p_Legislation_Code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)
124: is
125: select RANGE_TABLE_ID ,OBJECT_VERSION_NUMBER
126: from PAY_RANGE_TABLES_F
127: where LEGISLATION_CODE = p_Legislation_Code

Line 142: Legislation_Code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;

138: AND EFFECTIVE_END_DATE <= TO_DATE(p_effective_end_date,'YYYY/MM/DD HH24:MI:SS');
139:
140:
141: lr_Legislation_Code CSR_Legislation_Code%ROWTYPE;
142: Legislation_Code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;
143:
144: l_Ran_OBJECT_VERSION_NUMBER PAY_RANGES_F.OBJECT_VERSION_NUMBER%TYPE;
145: l_Prf_OBJECT_VERSION_NUMBER PAY_RANGE_TABLES_F.OBJECT_VERSION_NUMBER%TYPE;
146: