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 19: select /+ leading(smtmp) index(pce, PER_COMPETENCE_ELEMENTS_FK7) index(r1, PER_RATING_LEVELS_PK) /

15: where smtmp.mandatory = (p_mandatory);
16:
17: -- declare global cursor for essential/desired match count
18: CURSOR csr_ess_des_match_count(p_person_id in number, p_mandatory in varchar2)IS
19: select /*+ leading(smtmp) index(pce, PER_COMPETENCE_ELEMENTS_FK7) index(r1, PER_RATING_LEVELS_PK) */
20: count(pce.competence_id)
21: FROM per_competence_elements pce,
22: per_suitmatch_comp smtmp,
23: per_rating_levels r1

Line 21: FROM per_competence_elements pce,

17: -- declare global cursor for essential/desired match count
18: CURSOR csr_ess_des_match_count(p_person_id in number, p_mandatory in varchar2)IS
19: select /*+ leading(smtmp) index(pce, PER_COMPETENCE_ELEMENTS_FK7) index(r1, PER_RATING_LEVELS_PK) */
20: count(pce.competence_id)
21: FROM per_competence_elements pce,
22: per_suitmatch_comp smtmp,
23: per_rating_levels r1
24: where pce.competence_id = smtmp.competence_id
25: AND nvl(r1.step_value,-1) >= nvl(smtmp.min_step_value, -1)

Line 43: FROM per_competence_elements pce,

39: ,p_job_id in number
40: ,p_position_id in number
41: ,p_mandatory in varchar2) IS
42: SELECT count(pcep.competence_id)
43: FROM per_competence_elements pce,
44: per_competence_elements pcep,
45: per_rating_levels r1,
46: per_rating_levels r2
47: WHERE pce.type = 'REQUIREMENT'

Line 44: per_competence_elements pcep,

40: ,p_position_id in number
41: ,p_mandatory in varchar2) IS
42: SELECT count(pcep.competence_id)
43: FROM per_competence_elements pce,
44: per_competence_elements pcep,
45: per_rating_levels r1,
46: per_rating_levels r2
47: WHERE pce.type = 'REQUIREMENT'
48: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))

Line 72: FROM per_competence_elements pce

68: ,p_job_id in number
69: ,p_position_id in number
70: ,p_mandatory in varchar2) IS
71: SELECT count(pce.competence_id)
72: FROM per_competence_elements pce
73: WHERE pce.type = 'REQUIREMENT'
74: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
75: and nvl(pce.effective_date_to, trunc(sysdate))
76: AND (pce.enterprise_id = p_enterprise_id or pce.organization_id = p_organization_id or

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

83: -- work opp coming from temp table
84: CURSOR csr_wp_tmp_ed_match_count(
85: p_person_id in number
86: ,p_mandatory in varchar2) IS
87: SELECT /*+ leading(smtmp) index(pcep, PER_COMPETENCE_ELEMENTS_FK7) index(r2, PER_RATING_LEVELS_PK) */
88: count(pcep.competence_id)
89: FROM per_suitmatch_comp smtmp,
90: per_competence_elements pcep,
91: per_rating_levels r2

Line 90: per_competence_elements pcep,

86: ,p_mandatory in varchar2) IS
87: SELECT /*+ leading(smtmp) index(pcep, PER_COMPETENCE_ELEMENTS_FK7) index(r2, PER_RATING_LEVELS_PK) */
88: count(pcep.competence_id)
89: FROM per_suitmatch_comp smtmp,
90: per_competence_elements pcep,
91: per_rating_levels r2
92: WHERE pcep.person_id = p_person_id
93: AND smtmp.competence_id = pcep.competence_id
94: AND pcep.type = 'PERSONAL'

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

107: ,p_organization_id in number
108: ,p_job_id in number
109: ,p_position_id in number
110: ,p_mandatory in varchar2) IS
111: SELECT /*+ leading(ptmp) index(pce, PER_COMPETENCE_ELEMENTS_N1) index(r1, PER_RATING_LEVELS_PK) */
112: count(ptmp.competence_id)
113: FROM per_competence_elements pce,
114: per_suitmatch_person ptmp,
115: per_rating_levels r1

Line 113: FROM per_competence_elements pce,

109: ,p_position_id in number
110: ,p_mandatory in varchar2) IS
111: SELECT /*+ leading(ptmp) index(pce, PER_COMPETENCE_ELEMENTS_N1) index(r1, PER_RATING_LEVELS_PK) */
112: count(ptmp.competence_id)
113: FROM per_competence_elements pce,
114: per_suitmatch_person ptmp,
115: per_rating_levels r1
116: WHERE pce.type = 'REQUIREMENT'
117: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))

Line 227: FROM per_competence_elements pce,

223: r1.step_value low_step_value,
224: r2.step_value high_step_value,
225: pce.mandatory,
226: 'BUS' lookup_code
227: FROM per_competence_elements pce,
228: per_rating_levels r1,
229: per_rating_levels r2
230: WHERE pce.type = 'REQUIREMENT'
231: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))

Line 242: FROM per_competence_elements pce,

238: r1.step_value low_step_value,
239: r2.step_value high_step_value,
240: pce.mandatory,
241: 'ORG' lookup_code
242: FROM per_competence_elements pce,
243: per_rating_levels r1,
244: per_rating_levels r2
245: WHERE pce.type = 'REQUIREMENT'
246: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))

Line 257: FROM per_competence_elements pce,

253: r1.step_value low_step_value,
254: r2.step_value high_step_value,
255: pce.mandatory,
256: 'JOB' lookup_code
257: FROM per_competence_elements pce,
258: per_rating_levels r1,
259: per_rating_levels r2
260: WHERE pce.type = 'REQUIREMENT'
261: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))

Line 272: FROM per_competence_elements pce,

268: r1.step_value low_step_value,
269: r2.step_value high_step_value,
270: pce.mandatory,
271: 'POS' lookup_code
272: FROM per_competence_elements pce,
273: per_rating_levels r1,
274: per_rating_levels r2
275: WHERE pce.type = 'REQUIREMENT'
276: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))

Line 534: l_enterprise_id per_competence_elements.enterprise_id%type;

530:
531: )
532: IS
533:
534: l_enterprise_id per_competence_elements.enterprise_id%type;
535: l_organization_id per_competence_elements.organization_id%type;
536: l_job_id per_competence_elements.job_id%type;
537: l_position_id per_competence_elements.position_id%type;
538: l_vacancy_id per_all_vacancies.vacancy_id%type;

Line 535: l_organization_id per_competence_elements.organization_id%type;

531: )
532: IS
533:
534: l_enterprise_id per_competence_elements.enterprise_id%type;
535: l_organization_id per_competence_elements.organization_id%type;
536: l_job_id per_competence_elements.job_id%type;
537: l_position_id per_competence_elements.position_id%type;
538: l_vacancy_id per_all_vacancies.vacancy_id%type;
539: is_vac_pos boolean default false;

Line 536: l_job_id per_competence_elements.job_id%type;

532: IS
533:
534: l_enterprise_id per_competence_elements.enterprise_id%type;
535: l_organization_id per_competence_elements.organization_id%type;
536: l_job_id per_competence_elements.job_id%type;
537: l_position_id per_competence_elements.position_id%type;
538: l_vacancy_id per_all_vacancies.vacancy_id%type;
539: is_vac_pos boolean default false;
540:

Line 537: l_position_id per_competence_elements.position_id%type;

533:
534: l_enterprise_id per_competence_elements.enterprise_id%type;
535: l_organization_id per_competence_elements.organization_id%type;
536: l_job_id per_competence_elements.job_id%type;
537: l_position_id per_competence_elements.position_id%type;
538: l_vacancy_id per_all_vacancies.vacancy_id%type;
539: is_vac_pos boolean default false;
540:
541: BEGIN

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

602: )
603: IS
604: --cursor to get the suitable work opp ids
605: CURSOR csr_suit_workopps(p_person_id in number) IS
606: SELECT /*+ leading(pcp) index(pce, PER_COMPETENCE_ELEMENTS_N1) */
607: decode(pce.enterprise_id, null,
608: (decode(pce.organization_id, null,
609: (decode(pce.job_id, null,
610: (decode(pce.position_id,null,

Line 619: FROM per_competence_elements pce,

615: (decode(pce.job_id, null,
616: (decode(pce.position_id, null,
617: 'SM','POS')),'JOB')),'ORG')),'BUS') type,
618: ppf.person_id
619: FROM per_competence_elements pce,
620: per_suitmatch_person pcp,
621: per_all_people_f ppf
622: WHERE pce.type = 'REQUIREMENT'
623: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))

Line 934: l_enterprise_id per_competence_elements.enterprise_id%type;

930: )
931: RETURN VARCHAR2
932: IS PRAGMA AUTONOMOUS_TRANSACTION;
933:
934: l_enterprise_id per_competence_elements.enterprise_id%type;
935: l_organization_id per_competence_elements.organization_id%type;
936: l_job_id per_competence_elements.job_id%type;
937: l_position_id per_competence_elements.position_id%type;
938: l_vacancy_id per_all_vacancies.vacancy_id%type;

Line 935: l_organization_id per_competence_elements.organization_id%type;

931: RETURN VARCHAR2
932: IS PRAGMA AUTONOMOUS_TRANSACTION;
933:
934: l_enterprise_id per_competence_elements.enterprise_id%type;
935: l_organization_id per_competence_elements.organization_id%type;
936: l_job_id per_competence_elements.job_id%type;
937: l_position_id per_competence_elements.position_id%type;
938: l_vacancy_id per_all_vacancies.vacancy_id%type;
939: l_ess_des_match_count integer;

Line 936: l_job_id per_competence_elements.job_id%type;

932: IS PRAGMA AUTONOMOUS_TRANSACTION;
933:
934: l_enterprise_id per_competence_elements.enterprise_id%type;
935: l_organization_id per_competence_elements.organization_id%type;
936: l_job_id per_competence_elements.job_id%type;
937: l_position_id per_competence_elements.position_id%type;
938: l_vacancy_id per_all_vacancies.vacancy_id%type;
939: l_ess_des_match_count integer;
940: l_total_ess_des_count integer;

Line 937: l_position_id per_competence_elements.position_id%type;

933:
934: l_enterprise_id per_competence_elements.enterprise_id%type;
935: l_organization_id per_competence_elements.organization_id%type;
936: l_job_id per_competence_elements.job_id%type;
937: l_position_id per_competence_elements.position_id%type;
938: l_vacancy_id per_all_vacancies.vacancy_id%type;
939: l_ess_des_match_count integer;
940: l_total_ess_des_count integer;
941: is_vac_pos boolean default false;

Line 1041: l_enterprise_id per_competence_elements.enterprise_id%type;

1037: )
1038: RETURN VARCHAR2
1039: IS PRAGMA AUTONOMOUS_TRANSACTION;
1040:
1041: l_enterprise_id per_competence_elements.enterprise_id%type;
1042: l_organization_id per_competence_elements.organization_id%type;
1043: l_job_id per_competence_elements.job_id%type;
1044: l_position_id per_competence_elements.position_id%type;
1045: l_vacancy_id per_all_vacancies.vacancy_id%type;

Line 1042: l_organization_id per_competence_elements.organization_id%type;

1038: RETURN VARCHAR2
1039: IS PRAGMA AUTONOMOUS_TRANSACTION;
1040:
1041: l_enterprise_id per_competence_elements.enterprise_id%type;
1042: l_organization_id per_competence_elements.organization_id%type;
1043: l_job_id per_competence_elements.job_id%type;
1044: l_position_id per_competence_elements.position_id%type;
1045: l_vacancy_id per_all_vacancies.vacancy_id%type;
1046:

Line 1043: l_job_id per_competence_elements.job_id%type;

1039: IS PRAGMA AUTONOMOUS_TRANSACTION;
1040:
1041: l_enterprise_id per_competence_elements.enterprise_id%type;
1042: l_organization_id per_competence_elements.organization_id%type;
1043: l_job_id per_competence_elements.job_id%type;
1044: l_position_id per_competence_elements.position_id%type;
1045: l_vacancy_id per_all_vacancies.vacancy_id%type;
1046:
1047: l_ess_match_count integer;

Line 1044: l_position_id per_competence_elements.position_id%type;

1040:
1041: l_enterprise_id per_competence_elements.enterprise_id%type;
1042: l_organization_id per_competence_elements.organization_id%type;
1043: l_job_id per_competence_elements.job_id%type;
1044: l_position_id per_competence_elements.position_id%type;
1045: l_vacancy_id per_all_vacancies.vacancy_id%type;
1046:
1047: l_ess_match_count integer;
1048: l_total_ess_count integer;