APPS.PQH_UTILITY dependencies on HR_ALL_ORGANIZATION_UNITS

Line 77: l_business_group_id hr_all_organization_units.business_group_id%type;

73: l_proc varchar2(72) := g_package||'get_message_level_cd';
74: --
75: l_rule_set_id pqh_rules.rule_set_id%type;
76: l_rule_level_cd pqh_rule_sets.rule_level_cd%type;
77: l_business_group_id hr_all_organization_units.business_group_id%type;
78: l_record_found BOOLEAN := FALSE;
79: l_no_rule_sets number(10);
80: --
81: Cursor csr_rule_set is

Line 296: -- position transaction . Hence looking at hr_all_organization units to

292: -- Added on 17-jan-2001.
293: --
294: -- Retreiving the business group of the organization. A rule set may be created
295: -- for a business group also . Also , we support cross business groups in
296: -- position transaction . Hence looking at hr_all_organization units to
297: -- get the organizations business group.
298: --
299: Select business_group_id
300: From hr_all_organization_units a

Line 300: From hr_all_organization_units a

296: -- position transaction . Hence looking at hr_all_organization units to
297: -- get the organizations business group.
298: --
299: Select business_group_id
300: From hr_all_organization_units a
301: Where a.organization_id = p_organization_id;
302: --
303: l_proc varchar2(72) := g_package||'get_org_business_group_id';
304: --