43: end;
44: END BEFOREREPORT;
45:
46: FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2 IS
47: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;
48: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
49: SELECT
50: ORG_INFORMATION9
51: FROM
44: END BEFOREREPORT;
45:
46: FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2 IS
47: V_LEGISLATION_CODE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%TYPE := NULL;
48: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
49: SELECT
50: ORG_INFORMATION9
51: FROM
52: HR_ORGANIZATION_INFORMATION
48: CURSOR LEGISLATION_CODE(C_BUSINESS_GROUP_ID IN HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE) IS
49: SELECT
50: ORG_INFORMATION9
51: FROM
52: HR_ORGANIZATION_INFORMATION
53: WHERE ORGANIZATION_ID = C_BUSINESS_GROUP_ID
54: AND ORG_INFORMATION9 is not null;
55: BEGIN
56: OPEN LEGISLATION_CODE(P_BUSINESS_GROUP_ID);