APPS.HR_SUIT_MATCH_UTIL_SS dependencies on PER_SUITMATCH_PERSON

Line 114: per_suitmatch_person ptmp,

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))
118: and nvl(pce.effective_date_to, trunc(sysdate))

Line 133: per_suitmatch_person ptmp

129: CURSOR csr_tmp_ed_match_count(
130: p_mandatory in varchar2) IS
131: SELECT count(ptmp.competence_id)
132: FROM per_suitmatch_comp smtmp,
133: per_suitmatch_person ptmp
134: WHERE smtmp.competence_id = ptmp.competence_id
135: AND nvl(ptmp.min_step_value, -1) >= nvl(smtmp.min_step_value, -1)
136: AND smtmp.mandatory = p_mandatory;
137:

Line 620: per_suitmatch_person pcp,

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))
624: and nvl(pce.effective_date_to, trunc(sysdate))

Line 648: --insert the person competencies into per_suitmatch_person temp table

644: l_des_match_count integer;
645: l_total_des_count integer;
646:
647: BEGIN
648: --insert the person competencies into per_suitmatch_person temp table
649: DELETE FROM per_suitmatch_person;
650: FOR I IN 1 ..p_temp_tab.count LOOP
651: l_person_id := p_temp_tab(I).mandatory;
652: insert into per_suitmatch_person (competence_id,

Line 649: DELETE FROM per_suitmatch_person;

645: l_total_des_count integer;
646:
647: BEGIN
648: --insert the person competencies into per_suitmatch_person temp table
649: DELETE FROM per_suitmatch_person;
650: FOR I IN 1 ..p_temp_tab.count LOOP
651: l_person_id := p_temp_tab(I).mandatory;
652: insert into per_suitmatch_person (competence_id,
653: mandatory, min_step_value)

Line 652: insert into per_suitmatch_person (competence_id,

648: --insert the person competencies into per_suitmatch_person temp table
649: DELETE FROM per_suitmatch_person;
650: FOR I IN 1 ..p_temp_tab.count LOOP
651: l_person_id := p_temp_tab(I).mandatory;
652: insert into per_suitmatch_person (competence_id,
653: mandatory, min_step_value)
654: values (to_number(p_temp_tab(I).competence_id)
655: ,p_temp_tab(I).mandatory
656: ,to_number(p_temp_tab(I).min_step_value));

Line 659: --get suitable work opportunities using person competencies of per_suitmatch_person temp table

655: ,p_temp_tab(I).mandatory
656: ,to_number(p_temp_tab(I).min_step_value));
657: END LOOP;
658:
659: --get suitable work opportunities using person competencies of per_suitmatch_person temp table
660: OPEN csr_suit_workopps(l_person_id);
661: LOOP
662: EXIT WHEN csr_suit_workopps%NOTFOUND;
663: J := J + 1;