eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_UTIL_MISC_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 184: FROM per_competence_elements ce, per_all_assignments_f paf

180: ) RETURN VARCHAR2 IS
181:
182: CURSOR c_srcInfo (p_cid IN NUMBER, p_pid IN NUMBER) IS
183: SELECT 4 rank, hr_general.decode_lookup('STRUCTURE_TYPE','POS')||'#'||proficiency_level_id||'#'||high_proficiency_level_id src
184: FROM per_competence_elements ce, per_all_assignments_f paf
185: WHERE ce.type = 'REQUIREMENT'
186: AND trunc(sysdate) between nvl(ce.effective_date_from, sysdate) and nvl(ce.effective_date_to, sysdate)
187: AND ce.position_id = paf.position_id
188: AND paf.primary_flag = 'Y'

Line 196: FROM per_competence_elements ce, per_all_assignments_f paf

192: AND ce.competence_id = p_cid
193: AND paf.person_id = p_pid
194: UNION ALL
195: SELECT 3 rank, hr_general.decode_lookup('STRUCTURE_TYPE','JOB')||'#'||proficiency_level_id||'#'||high_proficiency_level_id src
196: FROM per_competence_elements ce, per_all_assignments_f paf
197: WHERE ce.type = 'REQUIREMENT'
198: AND trunc(sysdate) between nvl(ce.effective_date_from, sysdate) and nvl(ce.effective_date_to, sysdate)
199: AND ce.job_id = paf.job_id
200: AND paf.primary_flag = 'Y'

Line 208: FROM per_competence_elements ce, per_all_assignments_f paf

204: AND ce.competence_id = p_cid
205: AND paf.person_id = p_pid
206: UNION ALL
207: SELECT 2 rank, hr_general.decode_lookup('STRUCTURE_TYPE','ORG')||'#'||proficiency_level_id||'#'||high_proficiency_level_id src
208: FROM per_competence_elements ce, per_all_assignments_f paf
209: WHERE ce.type = 'REQUIREMENT'
210: AND trunc(sysdate) between ce.effective_date_from and nvl(ce.effective_date_to, sysdate)
211: AND ce.organization_id = paf.organization_id
212: AND paf.primary_flag = 'Y'

Line 220: FROM per_competence_elements ce, per_all_assignments_f paf

216: AND ce.competence_id = p_cid
217: AND paf.person_id = p_pid
218: UNION ALL
219: SELECT 1 rank, hr_general.decode_lookup('STRUCTURE_TYPE','BUS')||'#'||proficiency_level_id||'#'||high_proficiency_level_id src
220: FROM per_competence_elements ce, per_all_assignments_f paf
221: WHERE ce.type = 'REQUIREMENT'
222: AND trunc(sysdate) between ce.effective_date_from and nvl(ce.effective_date_to, sysdate)
223: AND ce.enterprise_id = paf.business_group_id
224: AND paf.primary_flag = 'Y'