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.HR_SUIT_MATCH_UTIL_SS dependencies on PER_COMPETENCE_ELEMENTS

Line 12: select /+ leading(smtmp) index(pce, PER_COMPETENCE_ELEMENTS_FK7) index(r1, PER_RATING_LEVELS_PK) /

8: where smtmp.mandatory = (p_mandatory);
9:
10: -- declare global cursor for essential/desired match count
11: CURSOR csr_ess_des_match_count(p_person_id in number, p_mandatory in varchar2)IS
12: select /*+ leading(smtmp) index(pce, PER_COMPETENCE_ELEMENTS_FK7) index(r1, PER_RATING_LEVELS_PK) */
13: count(pce.competence_id)
14: FROM per_competence_elements pce,
15: per_suitmatch_comp smtmp,
16: per_rating_levels r1

Line 14: FROM per_competence_elements pce,

10: -- declare global cursor for essential/desired match count
11: CURSOR csr_ess_des_match_count(p_person_id in number, p_mandatory in varchar2)IS
12: select /*+ leading(smtmp) index(pce, PER_COMPETENCE_ELEMENTS_FK7) index(r1, PER_RATING_LEVELS_PK) */
13: count(pce.competence_id)
14: FROM per_competence_elements pce,
15: per_suitmatch_comp smtmp,
16: per_rating_levels r1
17: where pce.competence_id = smtmp.competence_id
18: AND nvl(r1.step_value,-1) >= nvl(smtmp.min_step_value, -1)

Line 36: FROM per_competence_elements pce,

32: ,p_job_id in number
33: ,p_position_id in number
34: ,p_mandatory in varchar2) IS
35: SELECT count(pcep.competence_id)
36: FROM per_competence_elements pce,
37: per_competence_elements pcep,
38: per_rating_levels r1,
39: per_rating_levels r2
40: WHERE pce.type = 'REQUIREMENT'

Line 37: per_competence_elements pcep,

33: ,p_position_id in number
34: ,p_mandatory in varchar2) IS
35: SELECT count(pcep.competence_id)
36: FROM per_competence_elements pce,
37: per_competence_elements pcep,
38: per_rating_levels r1,
39: per_rating_levels r2
40: WHERE pce.type = 'REQUIREMENT'
41: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))

Line 65: FROM per_competence_elements pce

61: ,p_job_id in number
62: ,p_position_id in number
63: ,p_mandatory in varchar2) IS
64: SELECT count(pce.competence_id)
65: FROM per_competence_elements pce
66: WHERE pce.type = 'REQUIREMENT'
67: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
68: and nvl(pce.effective_date_to, trunc(sysdate))
69: AND (pce.enterprise_id = p_enterprise_id or pce.organization_id = p_organization_id or

Line 80: SELECT /+ leading(smtmp) index(pcep, PER_COMPETENCE_ELEMENTS_FK7) index(r2, PER_RATING_LEVELS_PK) /

76: -- work opp coming from temp table
77: CURSOR csr_wp_tmp_ed_match_count(
78: p_person_id in number
79: ,p_mandatory in varchar2) IS
80: SELECT /*+ leading(smtmp) index(pcep, PER_COMPETENCE_ELEMENTS_FK7) index(r2, PER_RATING_LEVELS_PK) */
81: count(pcep.competence_id)
82: FROM per_suitmatch_comp smtmp,
83: per_competence_elements pcep,
84: per_rating_levels r2

Line 83: per_competence_elements pcep,

79: ,p_mandatory in varchar2) IS
80: SELECT /*+ leading(smtmp) index(pcep, PER_COMPETENCE_ELEMENTS_FK7) index(r2, PER_RATING_LEVELS_PK) */
81: count(pcep.competence_id)
82: FROM per_suitmatch_comp smtmp,
83: per_competence_elements pcep,
84: per_rating_levels r2
85: WHERE pcep.person_id = p_person_id
86: AND smtmp.competence_id = pcep.competence_id
87: AND pcep.type = 'PERSONAL'

Line 104: SELECT /+ leading(ptmp) index(pce, PER_COMPETENCE_ELEMENTS_N1) index(r1, PER_RATING_LEVELS_PK) /

100: ,p_organization_id in number
101: ,p_job_id in number
102: ,p_position_id in number
103: ,p_mandatory in varchar2) IS
104: SELECT /*+ leading(ptmp) index(pce, PER_COMPETENCE_ELEMENTS_N1) index(r1, PER_RATING_LEVELS_PK) */
105: count(ptmp.competence_id)
106: FROM per_competence_elements pce,
107: per_suitmatch_person ptmp,
108: per_rating_levels r1

Line 106: FROM per_competence_elements pce,

102: ,p_position_id in number
103: ,p_mandatory in varchar2) IS
104: SELECT /*+ leading(ptmp) index(pce, PER_COMPETENCE_ELEMENTS_N1) index(r1, PER_RATING_LEVELS_PK) */
105: count(ptmp.competence_id)
106: FROM per_competence_elements pce,
107: per_suitmatch_person ptmp,
108: per_rating_levels r1
109: WHERE pce.type = 'REQUIREMENT'
110: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))

Line 220: FROM per_competence_elements pce,

216: r1.step_value low_step_value,
217: r2.step_value high_step_value,
218: pce.mandatory,
219: 'BUS' lookup_code
220: FROM per_competence_elements pce,
221: per_rating_levels r1,
222: per_rating_levels r2
223: WHERE pce.type = 'REQUIREMENT'
224: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))

Line 235: FROM per_competence_elements pce,

231: r1.step_value low_step_value,
232: r2.step_value high_step_value,
233: pce.mandatory,
234: 'ORG' lookup_code
235: FROM per_competence_elements pce,
236: per_rating_levels r1,
237: per_rating_levels r2
238: WHERE pce.type = 'REQUIREMENT'
239: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))

Line 250: FROM per_competence_elements pce,

246: r1.step_value low_step_value,
247: r2.step_value high_step_value,
248: pce.mandatory,
249: 'JOB' lookup_code
250: FROM per_competence_elements pce,
251: per_rating_levels r1,
252: per_rating_levels r2
253: WHERE pce.type = 'REQUIREMENT'
254: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))

Line 265: FROM per_competence_elements pce,

261: r1.step_value low_step_value,
262: r2.step_value high_step_value,
263: pce.mandatory,
264: 'POS' lookup_code
265: FROM per_competence_elements pce,
266: per_rating_levels r1,
267: per_rating_levels r2
268: WHERE pce.type = 'REQUIREMENT'
269: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))

Line 528: l_enterprise_id per_competence_elements.enterprise_id%type;

524:
525: )
526: IS
527:
528: l_enterprise_id per_competence_elements.enterprise_id%type;
529: l_organization_id per_competence_elements.organization_id%type;
530: l_job_id per_competence_elements.job_id%type;
531: l_position_id per_competence_elements.position_id%type;
532: l_vacancy_id per_all_vacancies.vacancy_id%type;

Line 529: l_organization_id per_competence_elements.organization_id%type;

525: )
526: IS
527:
528: l_enterprise_id per_competence_elements.enterprise_id%type;
529: l_organization_id per_competence_elements.organization_id%type;
530: l_job_id per_competence_elements.job_id%type;
531: l_position_id per_competence_elements.position_id%type;
532: l_vacancy_id per_all_vacancies.vacancy_id%type;
533: is_vac_pos boolean default false;

Line 530: l_job_id per_competence_elements.job_id%type;

526: IS
527:
528: l_enterprise_id per_competence_elements.enterprise_id%type;
529: l_organization_id per_competence_elements.organization_id%type;
530: l_job_id per_competence_elements.job_id%type;
531: l_position_id per_competence_elements.position_id%type;
532: l_vacancy_id per_all_vacancies.vacancy_id%type;
533: is_vac_pos boolean default false;
534:

Line 531: l_position_id per_competence_elements.position_id%type;

527:
528: l_enterprise_id per_competence_elements.enterprise_id%type;
529: l_organization_id per_competence_elements.organization_id%type;
530: l_job_id per_competence_elements.job_id%type;
531: l_position_id per_competence_elements.position_id%type;
532: l_vacancy_id per_all_vacancies.vacancy_id%type;
533: is_vac_pos boolean default false;
534:
535: BEGIN

Line 600: SELECT /+ leading(pcp) index(pce, PER_COMPETENCE_ELEMENTS_N1) /

596: )
597: IS
598: --cursor to get the suitable work opp ids
599: CURSOR csr_suit_workopps(p_person_id in number) IS
600: SELECT /*+ leading(pcp) index(pce, PER_COMPETENCE_ELEMENTS_N1) */
601: decode(pce.enterprise_id, null,
602: (decode(pce.organization_id, null,
603: (decode(pce.job_id, null,
604: (decode(pce.position_id,null,

Line 613: FROM per_competence_elements pce,

609: (decode(pce.job_id, null,
610: (decode(pce.position_id, null,
611: 'SM','POS')),'JOB')),'ORG')),'BUS') type,
612: ppf.person_id
613: FROM per_competence_elements pce,
614: per_suitmatch_person pcp,
615: per_all_people_f ppf
616: WHERE pce.type = 'REQUIREMENT'
617: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))

Line 923: l_enterprise_id per_competence_elements.enterprise_id%type;

919: )
920: RETURN VARCHAR2
921: IS PRAGMA AUTONOMOUS_TRANSACTION;
922:
923: l_enterprise_id per_competence_elements.enterprise_id%type;
924: l_organization_id per_competence_elements.organization_id%type;
925: l_job_id per_competence_elements.job_id%type;
926: l_position_id per_competence_elements.position_id%type;
927: l_vacancy_id per_all_vacancies.vacancy_id%type;

Line 924: l_organization_id per_competence_elements.organization_id%type;

920: RETURN VARCHAR2
921: IS PRAGMA AUTONOMOUS_TRANSACTION;
922:
923: l_enterprise_id per_competence_elements.enterprise_id%type;
924: l_organization_id per_competence_elements.organization_id%type;
925: l_job_id per_competence_elements.job_id%type;
926: l_position_id per_competence_elements.position_id%type;
927: l_vacancy_id per_all_vacancies.vacancy_id%type;
928: l_ess_des_match_count integer;

Line 925: l_job_id per_competence_elements.job_id%type;

921: IS PRAGMA AUTONOMOUS_TRANSACTION;
922:
923: l_enterprise_id per_competence_elements.enterprise_id%type;
924: l_organization_id per_competence_elements.organization_id%type;
925: l_job_id per_competence_elements.job_id%type;
926: l_position_id per_competence_elements.position_id%type;
927: l_vacancy_id per_all_vacancies.vacancy_id%type;
928: l_ess_des_match_count integer;
929: l_total_ess_des_count integer;

Line 926: l_position_id per_competence_elements.position_id%type;

922:
923: l_enterprise_id per_competence_elements.enterprise_id%type;
924: l_organization_id per_competence_elements.organization_id%type;
925: l_job_id per_competence_elements.job_id%type;
926: l_position_id per_competence_elements.position_id%type;
927: l_vacancy_id per_all_vacancies.vacancy_id%type;
928: l_ess_des_match_count integer;
929: l_total_ess_des_count integer;
930: is_vac_pos boolean default false;

Line 1023: l_enterprise_id per_competence_elements.enterprise_id%type;

1019: )
1020: RETURN VARCHAR2
1021: IS PRAGMA AUTONOMOUS_TRANSACTION;
1022:
1023: l_enterprise_id per_competence_elements.enterprise_id%type;
1024: l_organization_id per_competence_elements.organization_id%type;
1025: l_job_id per_competence_elements.job_id%type;
1026: l_position_id per_competence_elements.position_id%type;
1027: l_vacancy_id per_all_vacancies.vacancy_id%type;

Line 1024: l_organization_id per_competence_elements.organization_id%type;

1020: RETURN VARCHAR2
1021: IS PRAGMA AUTONOMOUS_TRANSACTION;
1022:
1023: l_enterprise_id per_competence_elements.enterprise_id%type;
1024: l_organization_id per_competence_elements.organization_id%type;
1025: l_job_id per_competence_elements.job_id%type;
1026: l_position_id per_competence_elements.position_id%type;
1027: l_vacancy_id per_all_vacancies.vacancy_id%type;
1028:

Line 1025: l_job_id per_competence_elements.job_id%type;

1021: IS PRAGMA AUTONOMOUS_TRANSACTION;
1022:
1023: l_enterprise_id per_competence_elements.enterprise_id%type;
1024: l_organization_id per_competence_elements.organization_id%type;
1025: l_job_id per_competence_elements.job_id%type;
1026: l_position_id per_competence_elements.position_id%type;
1027: l_vacancy_id per_all_vacancies.vacancy_id%type;
1028:
1029: l_ess_match_count integer;

Line 1026: l_position_id per_competence_elements.position_id%type;

1022:
1023: l_enterprise_id per_competence_elements.enterprise_id%type;
1024: l_organization_id per_competence_elements.organization_id%type;
1025: l_job_id per_competence_elements.job_id%type;
1026: l_position_id per_competence_elements.position_id%type;
1027: l_vacancy_id per_all_vacancies.vacancy_id%type;
1028:
1029: l_ess_match_count integer;
1030: l_total_ess_count integer;