25:
26: if p_tax_unit_id IS NOT NULL then
27:
28: Select name into cp_gre_name
29: from hr_organization_units
30: where organization_id = p_tax_unit_id;
31: end if;
32:
33: if p_person_id IS NOT NULL then
96: FUNCTION GET_BUSINESS_GROUP_NAME(fp_business_group_id IN NUMBER) RETURN VARCHAR2 IS
97:
98: CURSOR bg_cur IS
99: SELECT name
100: FROM hr_organization_units
101: WHERE organization_id = fp_business_group_id;
102: bgc bg_cur%ROWTYPE;
103:
104: BEGIN