APPS.IRC_UTILITIES_PKG dependencies on HR_ALL_POSITIONS

Line 1312: FROM hr_all_positions pos

1308: IS
1309: CURSOR csr_pos_fte IS
1310: SELECT pos.working_hours ,
1311: DECODE(pos.frequency ,'Y',1 ,'M',12 ,'W',52 ,'D',365 ,1)
1312: FROM hr_all_positions pos
1313: WHERE pos.position_id=p_position_id;
1314: CURSOR csr_org_fte IS
1315: SELECT fnd_number.canonical_to_number(org.org_information3) normal_hours ,
1316: DECODE(org.org_information4 ,'Y',1 ,'M',12 ,'W',52 ,'D',365 ,1)

Line 2068: FROM HR_ALL_POSITIONS_F

2064: END IF;
2065: IF(p_position_id IS NOT NULL) THEN
2066: SELECT name
2067: INTO l_position_name
2068: FROM HR_ALL_POSITIONS_F
2069: WHERE position_id = p_position_id
2070: AND TRUNC(sysdate) between effective_start_date and effective_end_date;
2071:
2072: OPEN csr_select_column_names('PER_POSITIONS');

Line 2079: || ' from hr_all_positions_f where position_id = '

2075:
2076: IF csr_select_column_names%found THEN
2077: query_stmt := 'select '
2078: || l_column_name
2079: || ' from hr_all_positions_f where position_id = '
2080: || p_position_id
2081: || ' AND TRUNC(sysdate) between effective_start_date and effective_end_date';
2082: EXECUTE immediate query_stmt INTO return_val;
2083: END IF;