APPS.OTA_COMPETENCE_SS dependencies on PER_COMPETENCES

Line 1970: , per_competences pc

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
1972: AND evt.parent_offering_id = off.offering_id
1973: AND evt.event_id = p_event_id
1974: and pce.competence_id = pc.competence_id

Line 1985: per_competences pc

1981: pc.competence_id,
1982: pc.renewal_period_frequency,
1983: pc.renewal_period_units
1984: FROM
1985: per_competences pc
1986: where
1987: pc.competence_id = p_competence_id
1988: AND pc.renewal_period_frequency IS NOT NULL
1989: --AND pc.renewal_period_units IS NOT NULL modified for bug8410902

Line 1999: , per_competences pc

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
2003: AND trunc(sysdate) between pc.DATE_FROM and nvl(pc.DATE_TO,(sysdate+1));

Line 2009: , per_competences pc

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
2013: AND trunc(sysdate) between pc.DATE_FROM and nvl(pc.DATE_TO,(sysdate+1));