DBA Data[Home] [Help]

APPS.GHR_SF113_A dependencies on HR_ORGANIZATION_INFORMATION

Line 52: l_col_name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION5%TYPE;

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

Line 56: FROM HR_ORGANIZATION_INFORMATION

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