37: end;
38:
39: function CF_legislation_codeFormula return VARCHAR2 is
40:
41: v_legislation_code hr_organization_information.org_information9%type := null;
42:
43: cursor legislation_code
44: (c_business_group_id hr_organization_information.organization_id%type) is
45:
40:
41: v_legislation_code hr_organization_information.org_information9%type := null;
42:
43: cursor legislation_code
44: (c_business_group_id hr_organization_information.organization_id%type) is
45:
46: select org_information9
47: from hr_organization_information
48: where organization_id = c_business_group_id
43: cursor legislation_code
44: (c_business_group_id hr_organization_information.organization_id%type) is
45:
46: select org_information9
47: from hr_organization_information
48: where organization_id = c_business_group_id
49: and org_information9 is not null
50: and org_information_context = 'Business Group Information';
51: begin