APPS.HXC_RESOURCE_RULES_UTILS dependencies on HR_SOFT_CODING_KEYFLEX

Line 572: FROM hr_soft_coding_keyflex

568: REPLACE( SUBSTR( REPLACE(concatenated_segments, '\'||p_delimiter, '\ ' ), (INSTR( REPLACE(concatenated_segments, '\'||p_delimiter, '\ ' ), p_delimiter, 1, (p_sequence-1))+1),
569: ( INSTR( REPLACE(concatenated_segments, '\'||p_delimiter, '\ ' ), p_delimiter, 1, p_sequence)
570: -(INSTR( REPLACE(concatenated_segments, '\'||p_delimiter, '\ ' ), p_delimiter, 1, (p_sequence-1))+1))), '\ ', p_delimiter )
571: ) meaning
572: FROM hr_soft_coding_keyflex
573: WHERE id_flex_num = p_id_flex_num
574: AND DECODE ( SUBSTR( p_type, 5 ),
575: 'SEGMENT1', segment1,
576: 'SEGMENT2', segment2,

Line 1177: FROM hr_soft_coding_keyflex scl

1173: cursor get_scl_segment_value IS
1174: select SEGMENT1,SEGMENT2,SEGMENT3,SEGMENT4,SEGMENT5,SEGMENT6,SEGMENT7,SEGMENT8,SEGMENT9,SEGMENT10,
1175: SEGMENT11,SEGMENT12,SEGMENT13,SEGMENT14,SEGMENT15,SEGMENT16,SEGMENT17,SEGMENT18,SEGMENT19,SEGMENT20,
1176: SEGMENT21,SEGMENT22,SEGMENT23,SEGMENT24,SEGMENT25,SEGMENT26,SEGMENT27,SEGMENT28,SEGMENT29,SEGMENT30
1177: FROM hr_soft_coding_keyflex scl
1178: WHERE scl.soft_coding_keyflex_id = p_flex_id;
1179:
1180:
1181: cursor get_people_segment_value IS