APPS.HR_COMP_OUTCOME_PROFILE_SS dependencies on PER_COMPETENCE_OUTCOMES_VL

Line 23: ,per_competence_outcomes_VL cvl

19: ,cmpe.OUTCOME_ID
20: ,cmpe.date_from
21: ,cmpe.date_to
22: from per_comp_element_outcomes cmpe
23: ,per_competence_outcomes_VL cvl
24: where cmpe.comp_element_outcome_id = p_comp_element_outcome_id
25: and cmpe.outcome_id = cvl.outcome_id
26: and trunc(sysdate) between nvl(cmpe.date_from, trunc(sysdate))
27: and nvl(cmpe.date_to, trunc(sysdate));

Line 30: from per_competence_outcomes_vl

26: and trunc(sysdate) between nvl(cmpe.date_from, trunc(sysdate))
27: and nvl(cmpe.date_to, trunc(sysdate));
28: cursor get_out_name(p_outcome_id in number) is
29: select name
30: from per_competence_outcomes_vl
31: where outcome_id = p_outcome_id;
32: cursor get_prev_start_date(p_comp_element_outcome_id in number) is
33: select date_from
34: from per_comp_element_outcomes

Line 684: l_outcome_name per_competence_outcomes_vl.name%type;

680: l_cmpout_element_rec per_comp_element_outcomes%rowtype;
681: l_system_generated varchar2(1) default null;
682: l_upgraded_from_rec_id number DEFAULT Null;
683: l_preupd_proficy_lvl_id number default NULL;
684: l_outcome_name per_competence_outcomes_vl.name%type;
685: l_txn_step_id hr_api_transaction_steps.transaction_step_id%type;
686: l_count number;
687: l_proc varchar2(200) ;
688: --

Line 943: from per_competence_outcomes_vl

939: --
940: Cursor get_out_dates ( p_outcome_id IN Number )is
941: select date_to end_date,
942: date_from start_date
943: from per_competence_outcomes_vl
944: where outcome_id = p_outcome_id;
945: --
946: l_out_dates_cur get_out_dates%RowType;
947: l_proc varchar2(200);

Line 1930: FROM hr_api_transaction_steps s, per_competence_outcomes_vl co,

1926: hr_utility.set_location(' Entering p_pid :' || p_pid ,10);
1927: hr_utility.set_location(' Entering p_competence_element_id :' || p_competence_element_id ,10);
1928: hr_utility.set_location(' Entering p_competence_id :' || p_competence_id ,10);
1929: Select Count(*) INTO l_count
1930: FROM hr_api_transaction_steps s, per_competence_outcomes_vl co,
1931: hr_api_transaction_values a, hr_api_transaction_values b,
1932: hr_api_transaction_values c, hr_api_transaction_values p
1933: Where s.item_type = p_item_type
1934: and s.item_key = p_item_key