APPS.PA_SEARCH_GLOB dependencies on PER_COMPETENCE_ELEMENTS

Line 19: FROM per_competence_elements pce

15: BEGIN
16:
17: --get mandatory and optional competence count for the requirement id
18: SELECT nvl(sum(decode(mandatory,'Y',1,0)),0), nvl(sum(decode(mandatory,'N',1,0)),0) INTO x_mandatory_count, x_optional_count
19: FROM per_competence_elements pce
20: WHERE pce.object_name = 'OPEN_ASSIGNMENT'
21: AND pce.object_id = p_requirement_id;
22:
23: --if the requirement has any competencies then get the mandatory/optional competence match

Line 29: FROM per_competence_elements pce,

25: IF (x_mandatory_count > 0 OR x_optional_count > 0) THEN
26:
27: --do mandatory and optional match
28: SELECT nvl(sum(decode(pce.mandatory,'Y',1,0)),0), nvl(sum(decode(pce.mandatory,'N',1,0)),0) INTO x_mandatory_match, x_optional_match
29: FROM per_competence_elements pce,
30: per_competence_elements pce2,
31: per_rating_levels prl,
32: per_rating_levels prl2
33: WHERE pce.object_id = p_requirement_id

Line 30: per_competence_elements pce2,

26:
27: --do mandatory and optional match
28: SELECT nvl(sum(decode(pce.mandatory,'Y',1,0)),0), nvl(sum(decode(pce.mandatory,'N',1,0)),0) INTO x_mandatory_match, x_optional_match
29: FROM per_competence_elements pce,
30: per_competence_elements pce2,
31: per_rating_levels prl,
32: per_rating_levels prl2
33: WHERE pce.object_id = p_requirement_id
34: AND pce.object_name = 'OPEN_ASSIGNMENT'