DBA Data[Home] [Help]

APPS.GHR_SF113_A dependencies on HR_ORGANIZATION_INFORMATION

Line 51: l_col_name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION5%TYPE;

47: -----
48: FUNCTION get_org_info( p_business_group_id in number)
49: return varchar2 IS
50: --
51: l_col_name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION5%TYPE;
52:
53: CURSOR get_segment IS
54: SELECT ORG_INFORMATION5
55: FROM HR_ORGANIZATION_INFORMATION

Line 55: FROM HR_ORGANIZATION_INFORMATION

51: l_col_name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION5%TYPE;
52:
53: CURSOR get_segment IS
54: SELECT ORG_INFORMATION5
55: FROM HR_ORGANIZATION_INFORMATION
56: WHERE ORG_INFORMATION_CONTEXT = 'GHR_US_ORG_INFORMATION'
57: AND ORGANIZATION_ID = p_business_group_id;
58: --
59: BEGIN