APPS.HXC_RESOURCE_RULES_UTILS dependencies on PER_GRADES

Line 492: -- FROM per_grades g

488: -- AND
489: -- ifs.id_flex_code = fl.id_Flex_code AND
490: -- ifs.id_flex_num = (
491: -- SELECT DISTINCT gd.id_flex_num
492: -- FROM per_grades g
493: -- , per_grade_Definitions gd
494: -- WHERE gd.grade_definition_id = g.grade_definition_id
495: -- AND g.business_group_id = p_business_group_id )
496: -- AND

Line 679: FROM per_grades_vl g

675: REPLACE( SUBSTR( REPLACE(g.name, '\'||p_delimiter, '\ '), (INSTR( REPLACE(g.name, '\'||p_delimiter, '\ '), p_delimiter, 1, (p_sequence-1))+1),
676: ( INSTR( REPLACE(g.name, '\'||p_delimiter, '\ '), p_delimiter, 1, p_sequence)
677: -(INSTR( REPLACE(g.name, '\'||p_delimiter, '\ '), p_delimiter, 1, (p_sequence-1))+1))), '\ ', p_delimiter)
678: ) meaning
679: FROM per_grades_vl g
680: , per_grade_definitions gd
681: WHERE gd.id_flex_num = p_id_flex_num
682: AND gd.grade_definition_id = g.grade_definition_id
683: AND DECODE ( SUBSTR( p_type, 7 ),

Line 999: -- , per_grades y

995: -- seg.id_flex_code= fl.id_flex_code AND
996: -- seg.id_flex_num = (
997: -- SELECT DISTINCT z.id_flex_num
998: -- FROM per_grade_definitions z
999: -- , per_grades y
1000: -- WHERE y.business_group_id = p_business_group_id
1001: -- AND y.grade_definition_id = z.grade_definition_id ) AND
1002: -- seg.display_flag = 'Y'
1003: -- AND

Line 1192: FROM per_grades g,per_grade_definitions gd

1188: cursor get_grade_segment_value IS
1189: select gd.SEGMENT1,gd.SEGMENT2,gd.SEGMENT3,gd.SEGMENT4,gd.SEGMENT5,gd.SEGMENT6,gd.SEGMENT7,gd.SEGMENT8,gd.SEGMENT9,gd.SEGMENT10,
1190: gd.SEGMENT11,gd.SEGMENT12,gd.SEGMENT13,gd.SEGMENT14,gd.SEGMENT15,gd.SEGMENT16,gd.SEGMENT17,gd.SEGMENT18,gd.SEGMENT19,gd.SEGMENT20,
1191: gd.SEGMENT21,gd.SEGMENT22,gd.SEGMENT23,gd.SEGMENT24,gd.SEGMENT25,gd.SEGMENT26,gd.SEGMENT27,gd.SEGMENT28,gd.SEGMENT29,gd.SEGMENT30
1192: FROM per_grades g,per_grade_definitions gd
1193: WHERE g.grade_id = p_flex_id
1194: AND gd.grade_definition_id = g.grade_definition_id;
1195:
1196: