63: SELECT
64: ORG_INFORMATION3
65: FROM
66: HR_ORGANIZATION_UNITS HOU,
67: HR_ORGANIZATION_INFORMATION HOI
68: WHERE HOI.ORGANIZATION_ID = P_LEGAL_EMPLOYER_LP
69: AND HOI.ORG_INFORMATION2 = P_TAX_STATE_LP
70: AND HOI.ORG_INFORMATION_CONTEXT = 'AU_PAYROLL_TAX_DGE';
71:
176: RETURN (TRUE);
177: END BEFOREREPORT;
178:
179: FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2 IS
180: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;
181: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
182: SELECT
183: ORG_INFORMATION9
184: FROM
177: END BEFOREREPORT;
178:
179: FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2 IS
180: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;
181: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
182: SELECT
183: ORG_INFORMATION9
184: FROM
185: HR_ORGANIZATION_INFORMATION
181: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
182: SELECT
183: ORG_INFORMATION9
184: FROM
185: HR_ORGANIZATION_INFORMATION
186: WHERE ORGANIZATION_ID = C_BUSINESS_GROUP_ID
187: AND ORG_INFORMATION9 is not null
188: AND ORG_INFORMATION_CONTEXT = 'Business Group Information';
189: BEGIN