[Home] [Help]
1098:
1099: -- Cursor to fetch GEO node at assignment EIT level
1100: CURSOR c_asg_geo_node (cp_assignment_id NUMBER) IS
1101: SELECT aei_information1
1102: FROM per_assignment_extra_info
1103: WHERE assignment_id = cp_assignment_id
1104: AND information_type = FND_PROFILE.value('HR_GEO_HIER_NODE_MAP')
1105: AND aei_information_category = FND_PROFILE.value('HR_GEO_HIER_NODE_MAP');
1106: