APPS.GHR_BREAKDOWN_RPT dependencies on HR_ALL_POSITIONS_F

Line 76: l_orgid hr_all_positions_f.organization_id%TYPE;

72: FUNCTION get_hierarchy_level(p_position_id IN NUMBER, p_effective_date IN DATE)
73: RETURN NUMBER
74: IS
75: l_level NUMBER(3);
76: l_orgid hr_all_positions_f.organization_id%TYPE;
77: CURSOR c_level IS
78: SELECT DECODE(ORG.organization_id_child, l_orgid, LEVEL+1, LEVEL) ORG_LEVEL
79: FROM per_org_structure_elements ORG
80: WHERE (ORG.organization_id_child = l_orgid OR

Line 96: FROM hr_all_positions_f

92: l_level := 0;
93: IF l_for_clause > 0 THEN
94: SELECT organization_id
95: INTO l_orgid
96: FROM hr_all_positions_f
97: WHERE position_id = p_position_id
98: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
99: OPEN c_level;
100: FETCH c_level INTO l_level;

Line 128: FROM hr_all_positions_f POS,

124: BY
125: PRIOR organization_id_parent = organization_id_child
126: START
127: WITH organization_id_child = (SELECT POS.organization_id
128: FROM hr_all_positions_f POS,
129: per_assignments_f ASG
130: WHERE ASG.rowid = p_ASG_rowid
131: AND ASG.position_id = POS.position_id
132: AND p_effective_date BETWEEN POS.effective_start_date

Line 162: FROM hr_all_positions_f POS,

158: l_result := l_result || '-' || l_prvorg;
159: ELSIF l_result IS NULL AND p_mode = 'PARENTS' THEN
160: SELECT POS.organization_id
161: INTO l_result
162: FROM hr_all_positions_f POS,
163: per_assignments_f ASG
164: WHERE ASG.rowid = p_ASG_rowid
165: AND ASG.position_id = POS.position_id
166: AND p_effective_date BETWEEN POS.effective_start_date

Line 324: FROM hr_all_positions_f POS,

320: ELSIF p_clause = 'SERIES' -- Occupational Series
321: THEN
322: SELECT job.name || ' - ' || decode_lookup('GHR_US_OCC_SERIES', job.name)
323: INTO l_result
324: FROM hr_all_positions_f POS,
325: per_jobs job
326: WHERE POS.position_id = p_ASG.position_id
327: AND TRUNC(effective_date) BETWEEN POS.effective_start_date
328: AND POS.effective_end_date

Line 454: FROM hr_all_positions_f POS

450: p_ASG.business_group_id);
451: ELSIF p_clause = 'ORGANIZATION_ID' THEN
452: SELECT POS.organization_id
453: INTO l_result
454: FROM hr_all_positions_f POS
455: WHERE POS.position_id = p_ASG.position_id
456: AND TRUNC(l_effective_date) BETWEEN POS.effective_start_date
457: AND POS.effective_end_date;
458: END IF;