APPS.PER_CN_SHARED_INFO dependencies on PER_ANALYSIS_CRITERIA

Line 199: select per_cn_shared_info.get_lookup_meaning(segment1,'CN_CADRE_JOB_CLASS') from PER_ANALYSIS_CRITERIA

195: )
196: order by date_from desc;
197:
198: CURSOR get_details(p_anal_cri_id IN NUMBER) IS
199: select per_cn_shared_info.get_lookup_meaning(segment1,'CN_CADRE_JOB_CLASS') from PER_ANALYSIS_CRITERIA
200: where ANALYSIS_CRITERIA_ID = p_anal_cri_id
201: and enabled_flag = 'Y';
202:
203: l_cad_job_class varchar2(1000);

Line 242: select per_cn_shared_info.get_lookup_meaning(segment1,'CN_TECH_TITLE') from PER_ANALYSIS_CRITERIA

238: )
239: order by date_from desc;
240:
241: CURSOR get_details(p_anal_cri_id IN NUMBER) IS
242: select per_cn_shared_info.get_lookup_meaning(segment1,'CN_TECH_TITLE') from PER_ANALYSIS_CRITERIA
243: where ANALYSIS_CRITERIA_ID = p_anal_cri_id
244: and enabled_flag = 'Y';
245:
246: l_cri_id NUMBER;