APPS.HR_SUIT_MATCH_UTILITY_WEB dependencies on PER_VALID_GRADES

Line 694: ||' FROM per_valid_grades pvg,'

690:
691: IF p_search_type = g_job_type THEN
692: l_dynamic_sql := 'SELECT distinct(pvg.valid_grade_id),'
693: ||l_flex_select_clause
694: ||' FROM per_valid_grades pvg,'
695: ||' per_grades pg, per_grade_definitions pgd'
696: ||' WHERE pvg.job_id = '||p_id
697: ||' AND pvg.grade_id = pg.grade_id'
698: ||' AND pg.grade_definition_id = pgd.grade_definition_id';

Line 702: ||' FROM per_valid_grades pvg,'

698: ||' AND pg.grade_definition_id = pgd.grade_definition_id';
699: ELSIF p_search_type = g_position_type THEN
700: l_dynamic_sql := 'SELECT distinct(pvg.valid_grade_id),'
701: ||l_flex_select_clause
702: ||' FROM per_valid_grades pvg,'
703: ||' per_grades pg, per_grade_definitions pgd'
704: ||' WHERE pvg.position_id = '||p_id
705: ||' AND pvg.grade_id = pg.grade_id'
706: ||' AND pg.grade_definition_id = pgd.grade_definition_id';

Line 1768: from per_valid_grades pvg

1764: WHERE pce.job_id = p_job_id
1765: AND (pce.valid_grade_id IS null
1766: -- OR pce.valid_grade_id = p_grade_id)
1767: OR pce.valid_grade_id in (select pvg.valid_grade_id
1768: from per_valid_grades pvg
1769: where pvg.grade_id = p_grade_id
1770: and trunc(sysdate) between pvg.DATE_FROM and
1771: nvl(pvg.DATE_TO, trunc(sysdate))))
1772: AND pce.type = 'REQUIREMENT'

Line 1881: from per_valid_grades pvg

1877: WHERE pce.position_id = p_pos_id
1878: AND (pce.valid_grade_id IS null
1879: -- OR pce.valid_grade_id = p_grade_id)
1880: OR pce.valid_grade_id in (select pvg.valid_grade_id
1881: from per_valid_grades pvg
1882: where pvg.grade_id = p_grade_id
1883: and trunc(sysdate) between pvg.DATE_FROM and
1884: nvl(pvg.DATE_TO, trunc(sysdate))))
1885: AND pce.type = 'REQUIREMENT'

Line 3099: ||' FROM per_valid_grades pvg'

3095: IF p_grade_id IS NOT null THEN
3096: l_dynamic_sql := l_dynamic_sql
3097: ||' AND paf.grade_id = '
3098: ||' (SELECT pvg.grade_id'
3099: ||' FROM per_valid_grades pvg'
3100: ||' WHERE pvg.valid_grade_id = '
3101: ||p_grade_id||')';
3102: END IF;
3103: ELSIF p_search_type = g_position_type THEN

Line 3111: ||' FROM per_valid_grades pvg'

3107: IF p_grade_id IS NOT null THEN
3108: l_dynamic_sql := l_dynamic_sql
3109: ||' AND paf.grade_id = '
3110: ||' (SELECT pvg.grade_id'
3111: ||' FROM per_valid_grades pvg'
3112: ||' WHERE pvg.valid_grade_id = '
3113: ||p_grade_id||')';
3114: END IF;
3115: END IF;

Line 3133: ||' FROM per_valid_grades pvg'

3129: IF p_grade_id IS NOT null THEN
3130: l_dynamic_sql := l_dynamic_sql
3131: ||' AND paf.grade_id = '
3132: ||' (SELECT pvg.grade_id'
3133: ||' FROM per_valid_grades pvg'
3134: ||' WHERE pvg.valid_grade_id = '
3135: ||p_grade_id||')';
3136: END IF;
3137: ELSIF p_pre_search_type = g_position_type THEN

Line 3145: ||' FROM per_valid_grades pvg'

3141: IF p_grade_id IS NOT null THEN
3142: l_dynamic_sql := l_dynamic_sql
3143: ||' AND paf.grade_id = '
3144: ||' (SELECT pvg.grade_id'
3145: ||' FROM per_valid_grades pvg'
3146: ||' WHERE pvg.valid_grade_id = '
3147: ||p_grade_id||')';
3148: END IF;
3149: END IF;