APPS.OTA_COMPETENCE_SS dependencies on PER_COMPETENCE_ELEMENTS

Line 178: p_comp_id in per_competence_elements.competence_id%type,

174: -- |----------------------< get_Comptence_eff_date >--------------------------|
175: -- ---------------------------------------------------------------------------
176: --
177: Function get_Competence_eff_date(
178: p_comp_id in per_competence_elements.competence_id%type,
179: p_id in ota_events.event_id%type,
180: p_obj_type in varchar2
181: ) return date
182: is

Line 198: from per_competence_elements pce , ota_offerings off,ota_events oev

194: and (oev.parent_offering_id = off.offering_id or oev.offering_id = off.offering_id)
195: and off.delivery_mode_id = ocu.category_usage_id
196: and ocu.synchronous_flag = 'Y';
197: /*select pce.effective_date_from
198: from per_competence_elements pce , ota_offerings off,ota_events oev
199: where oev.parent_offering_id=off.offering_id
200: and off.activity_version_id=pce.activity_version_id
201: and oev.event_id= p_id
202: and pce.competence_id =p_comp_id

Line 209: from per_competence_elements pce

205:
206:
207: /*Cursor lp_eff_date is
208: select pce.effective_date_from
209: from per_competence_elements pce
210: where pce.object_id= p_id
211: and pce.competence_id =p_comp_id
212: and type='OTA_LEARNING_PATH';*/
213:

Line 962: from per_competence_elements

958: l_msg_name varchar2(1000);
959:
960: Cursor Comp_level(CompId number,personId number) is
961: Select Proficiency_level_id
962: from per_competence_elements
963: where Competence_id = CompId
964: and person_id = personId;
965:
966:

Line 1313: from per_competence_elements

1309: return varchar2 is
1310:
1311: Cursor Comp_level(CompId number,personId number) is
1312: Select Proficiency_level_id
1313: from per_competence_elements
1314: where Competence_id = CompId
1315: and person_id = personId;
1316:
1317: l_person_id number(15):= p_person_id;

Line 1967: FROM per_competence_elements pce

1963: --active competencies(i.e to not retrieve end dated competencies)
1964: CURSOR csr_get_crs_comps IS
1965: SELECT pce.competence_id CompetenceId
1966: ,nvl(pce.proficiency_level_id,-1) LevelId
1967: FROM per_competence_elements pce
1968: , ota_offerings OFF
1969: , ota_events EVT
1970: , per_competences pc
1971: WHERE off.activity_version_id = pce.activity_version_id

Line 1998: FROM per_competence_elements pce

1994:
1995: CURSOR csr_get_lp_comps IS
1996: SELECT pce.competence_id CompetenceId
1997: ,nvl(pce.proficiency_level_id,-1) LevelId
1998: FROM per_competence_elements pce
1999: , per_competences pc
2000: WHERE pce.type = 'OTA_LEARNING_PATH'
2001: AND pce.object_id = l_learning_path_id
2002: AND pce.competence_id = pc.competence_id

Line 2008: FROM per_competence_elements pce

2004:
2005: CURSOR csr_get_cert_comps IS
2006: SELECT pce.competence_id CompetenceId
2007: ,nvl(pce.proficiency_level_id,-1) LevelId
2008: FROM per_competence_elements pce
2009: , per_competences pc
2010: WHERE pce.type = 'OTA_CERTIFICATION' ---Batra to revisit*********************
2011: AND pce.object_id = p_certification_id
2012: AND pce.competence_id = pc.competence_id