APPS.GHR_MRE_PKG dependencies on PER_POS_STRUCTURE_VERSIONS

Line 57: per_pos_structure_versions b

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'
61: and org_pos_fl = 'P'