DBA Data[Home] [Help]

APPS.HXC_RESOURCE_RULES_UTILS dependencies on HR_SOFT_CODING_KEYFLEX

Line 570: FROM hr_soft_coding_keyflex

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

Line 1170: FROM hr_soft_coding_keyflex scl

1166: cursor get_scl_segment_value IS
1167: select SEGMENT1,SEGMENT2,SEGMENT3,SEGMENT4,SEGMENT5,SEGMENT6,SEGMENT7,SEGMENT8,SEGMENT9,SEGMENT10,
1168: SEGMENT11,SEGMENT12,SEGMENT13,SEGMENT14,SEGMENT15,SEGMENT16,SEGMENT17,SEGMENT18,SEGMENT19,SEGMENT20,
1169: SEGMENT21,SEGMENT22,SEGMENT23,SEGMENT24,SEGMENT25,SEGMENT26,SEGMENT27,SEGMENT28,SEGMENT29,SEGMENT30
1170: FROM hr_soft_coding_keyflex scl
1171: WHERE scl.soft_coding_keyflex_id = p_flex_id;
1172:
1173:
1174: cursor get_people_segment_value IS