DBA Data[Home] [Help]

APPS.GHR_MRE_PKG dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 56: from per_pos_structure_elements a,

52: and b.business_group_id = g_business_group_id
53: and org_pos_fl = 'O'
54: union
55: SELECT a.subordinate_position_id org_pos_id
56: from per_pos_structure_elements a,
57: per_pos_structure_versions b
58: WHERE a.pos_structure_version_id = b.pos_structure_version_id
59: and a.pos_structure_version_id = org_str_id
60: and child_fl = 'Y'

Line 65: from per_pos_structure_elements

61: and org_pos_fl = 'P'
62: and a.pos_structure_element_id in
63: (
64: SELECT pos_structure_element_id
65: from per_pos_structure_elements
66: start with parent_position_id = cp_org_pos_id
67: connect by prior subordinate_position_id = parent_position_id
68: )
69: union