APPS.PA_SEARCH_GLOB dependencies on PA_SEARCH_GLOB

Line 1: PACKAGE BODY PA_SEARCH_GLOB AS

1: PACKAGE BODY PA_SEARCH_GLOB AS
2: --$Header: PARIGLBB.pls 120.2 2006/06/21 04:30:14 avaithia noship $
3: --
4:
5:

Line 39: AND decode(prl2.step_value, NULL, decode(prl.step_value, NULL, -999, PA_SEARCH_GLOB.get_min_prof_level(pce2.competence_id)), prl2.step_value) >= nvl(prl.step_value, nvl(prl2.step_value , -999));

35: AND pce.proficiency_level_id = prl.rating_level_id(+)
36: AND pce.competence_id = pce2.competence_id
37: AND pce2.person_id = p_person_id
38: AND pce2.proficiency_level_id = prl2.rating_level_id(+)
39: AND decode(prl2.step_value, NULL, decode(prl.step_value, NULL, -999, PA_SEARCH_GLOB.get_min_prof_level(pce2.competence_id)), prl2.step_value) >= nvl(prl.step_value, nvl(prl2.step_value , -999));
40:
41: ELSE
42: x_mandatory_match :=0;
43: x_optional_match := 0;

Line 166: END PA_SEARCH_GLOB;

162:
163: END;
164:
165:
166: END PA_SEARCH_GLOB;