eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_CEO_BUS dependencies on PER_COMPETENCE_OUTCOMES

Line 390: -- per_competence_outcomes table

386: --
387: -- Desciption :
388: --
389: -- Validates that compence_id is mandatory and foreign key to
390: -- per_competence_outcomes table
391: --
392: -- Pre-conditions:
393: -- None
394: --

Line 423: select 'x' from per_competence_outcomes

419: --
420: -- Declare cursor
421: --
422: cursor csr_competence_outcome is
423: select 'x' from per_competence_outcomes
424: where outcome_id = p_outcome_id;
425:
426: --
427: -- Declare local variables

Line 542: l_outcome_name per_competence_outcomes.name%type;

538: and o.outcome_id = p_outcome_id
539: and p_date_from < nvl(o.date_to,hr_api.g_eot)
540: and nvl(p_date_to,hr_api.g_eot) > o.date_from;*/
541:
542: l_outcome_name per_competence_outcomes.name%type;
543:
544: cursor csr_upd_uniq_comp_ele_outcome(p_name per_competence_outcomes.name%type)is
545: select 'x' from per_comp_element_outcomes o,per_competence_outcomes co
546: where o.comp_element_outcome_id <> p_comp_element_outcome_id

Line 544: cursor csr_upd_uniq_comp_ele_outcome(p_name per_competence_outcomes.name%type)is

540: and nvl(p_date_to,hr_api.g_eot) > o.date_from;*/
541:
542: l_outcome_name per_competence_outcomes.name%type;
543:
544: cursor csr_upd_uniq_comp_ele_outcome(p_name per_competence_outcomes.name%type)is
545: select 'x' from per_comp_element_outcomes o,per_competence_outcomes co
546: where o.comp_element_outcome_id <> p_comp_element_outcome_id
547: and o.competence_element_id = p_competence_element_id
548: and co.outcome_id = o.outcome_id

Line 545: select 'x' from per_comp_element_outcomes o,per_competence_outcomes co

541:
542: l_outcome_name per_competence_outcomes.name%type;
543:
544: cursor csr_upd_uniq_comp_ele_outcome(p_name per_competence_outcomes.name%type)is
545: select 'x' from per_comp_element_outcomes o,per_competence_outcomes co
546: where o.comp_element_outcome_id <> p_comp_element_outcome_id
547: and o.competence_element_id = p_competence_element_id
548: and co.outcome_id = o.outcome_id
549: and co.name = p_name

Line 590: from per_competence_outcomes

586: hr_utility.set_location(l_proc, 20);
587:
588: select name
589: into l_outcome_name
590: from per_competence_outcomes
591: where outcome_id = p_outcome_id;
592:
593: --
594: open csr_upd_uniq_comp_ele_outcome(l_outcome_name);

Line 670: select date_from from per_competence_outcomes cpo

666: ) is
667: --
668:
669: cursor csr_get_outcome_active_date is
670: select date_from from per_competence_outcomes cpo
671: where cpo.outcome_id = p_outcome_id ;
672:
673: l_outcome_active_date date ;
674: l_proc varchar2(72) := g_package||'chk_dates';

Line 1206: select count(cpo.outcome_id) from per_competence_outcomes cpo

1202: --
1203: -- Declare cursors and local variables
1204: --
1205: cursor csr_get_outcome_number is
1206: select count(cpo.outcome_id) from per_competence_outcomes cpo
1207: where cpo.competence_id = p_competence_id
1208: and p_effective_date between date_from
1209: and nvl(date_to,hr_api.g_eot);
1210:

Line 1219: select cpo2.outcome_id from per_competence_outcomes cpo2

1215: where ceo.competence_element_id = p_competence_element_id
1216: -- and p_effective_date between ceo.date_from
1217: -- and nvl(date_to,hr_api.g_eot)
1218: and ceo.outcome_id in (
1219: select cpo2.outcome_id from per_competence_outcomes cpo2
1220: where cpo2.competence_id = p_competence_id
1221: and p_effective_date between cpo2.date_from
1222: and nvl(cpo2.date_to,hr_api.g_eot));
1223: