APPS.HXC_RESOURCE_RULES_UTILS dependencies on PAY_PEOPLE_GROUPS

Line 413: -- , pay_people_groups z

409: -- ifs.id_flex_code = fl.id_Flex_code AND
410: -- ifs.id_flex_num = (
411: -- SELECT DISTINCT z.id_flex_num
412: -- FROM per_all_assignments_f asg
413: -- , pay_people_groups z
414: -- WHERE asg.people_group_id = z.people_group_id
415: -- AND asg.business_group_id = p_business_group_id )
416: -- AND
417: -- seg.id_flex_num = ifs.id_flex_num AND

Line 626: FROM pay_people_groups

622: REPLACE( SUBSTR( REPLACE(group_name, '\'||p_delimiter, '\ ' ), (INSTR( REPLACE(group_name, '\'||p_delimiter, '\ ' ), p_delimiter, 1, (p_sequence-1))+1),
623: ( INSTR( REPLACE(group_name, '\'||p_delimiter, '\ ' ), p_delimiter, 1, p_sequence)
624: -(INSTR( REPLACE(group_name, '\'||p_delimiter, '\ ' ), p_delimiter, 1, (p_sequence-1))+1))), '\ ', p_delimiter )
625: ) meaning
626: FROM pay_people_groups
627: WHERE id_flex_num = p_id_flex_num
628: AND DECODE ( SUBSTR( p_type, 8 ),
629: 'SEGMENT1', segment1,
630: 'SEGMENT2', segment2,

Line 913: -- , pay_people_groups z

909: -- seg.id_flex_code= fl.id_flex_code AND
910: -- seg.id_flex_num = (
911: -- SELECT DISTINCT z.id_flex_num
912: -- FROM per_all_assignments_f asg
913: -- , pay_people_groups z
914: -- WHERE asg.people_group_id = z.people_group_id
915: -- AND asg.business_group_id = p_business_group_id ) AND
916: -- seg.display_flag = 'Y'
917: -- AND

Line 1185: FROM pay_people_groups grp

1181: cursor get_people_segment_value IS
1182: select SEGMENT1,SEGMENT2,SEGMENT3,SEGMENT4,SEGMENT5,SEGMENT6,SEGMENT7,SEGMENT8,SEGMENT9,SEGMENT10,
1183: SEGMENT11,SEGMENT12,SEGMENT13,SEGMENT14,SEGMENT15,SEGMENT16,SEGMENT17,SEGMENT18,SEGMENT19,SEGMENT20,
1184: SEGMENT21,SEGMENT22,SEGMENT23,SEGMENT24,SEGMENT25,SEGMENT26,SEGMENT27,SEGMENT28,SEGMENT29,SEGMENT30
1185: FROM pay_people_groups grp
1186: WHERE grp.people_group_id = p_flex_id;
1187:
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,