APPS.HR_COMP_OUTCOME_PROFILE_SS dependencies on PER_COMPETENCE_ELEMENTS

Line 521: From per_competence_elements ce

517: AND C.NAME = 'P_COMP_ELEMENT_OUTCOME_ID'
518: AND ceo.comp_element_outcome_id = C.number_value);
519: Cursor get_new_compele_dtls( p_new_comp_ele_id IN number) is
520: Select ce.Effective_date_From,ce.Effective_date_to
521: From per_competence_elements ce
522: Where ce.COMPETENCE_ELEMENT_ID = p_new_comp_ele_id;
523: /* Select ceo.outcome_id,ceo.date_from,ceo.date_to,
524: ce.Effective_date_From,ce.Effective_date_to, ceo.object_version_number
525: From per_comp_element_outcomes ceo,

Line 526: per_competence_elements ce

522: Where ce.COMPETENCE_ELEMENT_ID = p_new_comp_ele_id;
523: /* Select ceo.outcome_id,ceo.date_from,ceo.date_to,
524: ce.Effective_date_From,ce.Effective_date_to, ceo.object_version_number
525: From per_comp_element_outcomes ceo,
526: per_competence_elements ce
527: Where ceo.competence_element_id = p_comp_ele_id
528: AND ce.competence_element_id = p_new_comp_ele_id;*/
529: --
530: TYPE new_compele_dtl_rec is RECORD (

Line 531: Effective_date_From per_competence_elements.Effective_date_From%TYPE,

527: Where ceo.competence_element_id = p_comp_ele_id
528: AND ce.competence_element_id = p_new_comp_ele_id;*/
529: --
530: TYPE new_compele_dtl_rec is RECORD (
531: Effective_date_From per_competence_elements.Effective_date_From%TYPE,
532: Effective_date_to per_competence_elements.Effective_date_to%TYPE
533: );
534: new_compele_dtl_record new_compele_dtl_rec;
535: l_count number;

Line 532: Effective_date_to per_competence_elements.Effective_date_to%TYPE

528: AND ce.competence_element_id = p_new_comp_ele_id;*/
529: --
530: TYPE new_compele_dtl_rec is RECORD (
531: Effective_date_From per_competence_elements.Effective_date_From%TYPE,
532: Effective_date_to per_competence_elements.Effective_date_to%TYPE
533: );
534: new_compele_dtl_record new_compele_dtl_rec;
535: l_count number;
536: l_Start_Date per_Comp_Element_Outcomes.Date_from%type;

Line 1880: per_competence_elements pce

1876: SELECT s.transaction_step_id INTO l_txn_step_id
1877: FROM hr_api_transaction_steps S,
1878: hr_api_transaction_values C,
1879: per_comp_element_outcomes ceo,
1880: per_competence_elements pce
1881: Where s.item_type = p_item_type
1882: and s.item_key = p_item_key
1883: and s.activity_id = nvl((p_actid),s.activity_id)
1884: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'