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 672: FROM per_grades_vl g

668: p_max_sequence, SUBSTR( g.name, INSTR( g.name, p_delimiter, 1, (p_sequence-1))+1),
669: SUBSTR( g.name, (INSTR( g.name, p_delimiter, 1, (p_sequence-1))+1),
670: ( INSTR( g.name, p_delimiter, 1, p_sequence)
671: -(INSTR( g.name, p_delimiter, 1, (p_sequence-1))+1)))) meaning
672: FROM per_grades_vl g
673: , per_grade_definitions gd
674: WHERE gd.id_flex_num = p_id_flex_num
675: AND gd.grade_definition_id = g.grade_definition_id
676: AND DECODE ( SUBSTR( p_type, 7 ),

Line 992: -- , per_grades y

988: -- seg.id_flex_code= fl.id_flex_code AND
989: -- seg.id_flex_num = (
990: -- SELECT DISTINCT z.id_flex_num
991: -- FROM per_grade_definitions z
992: -- , per_grades y
993: -- WHERE y.business_group_id = p_business_group_id
994: -- AND y.grade_definition_id = z.grade_definition_id ) AND
995: -- seg.display_flag = 'Y'
996: -- AND

Line 1185: FROM per_grades g,per_grade_definitions gd

1181: cursor get_grade_segment_value IS
1182: select gd.SEGMENT1,gd.SEGMENT2,gd.SEGMENT3,gd.SEGMENT4,gd.SEGMENT5,gd.SEGMENT6,gd.SEGMENT7,gd.SEGMENT8,gd.SEGMENT9,gd.SEGMENT10,
1183: gd.SEGMENT11,gd.SEGMENT12,gd.SEGMENT13,gd.SEGMENT14,gd.SEGMENT15,gd.SEGMENT16,gd.SEGMENT17,gd.SEGMENT18,gd.SEGMENT19,gd.SEGMENT20,
1184: gd.SEGMENT21,gd.SEGMENT22,gd.SEGMENT23,gd.SEGMENT24,gd.SEGMENT25,gd.SEGMENT26,gd.SEGMENT27,gd.SEGMENT28,gd.SEGMENT29,gd.SEGMENT30
1185: FROM per_grades g,per_grade_definitions gd
1186: WHERE g.grade_id = p_flex_id
1187: AND gd.grade_definition_id = g.grade_definition_id;
1188:
1189: