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 621: FROM pay_people_groups

617: p_max_sequence, SUBSTR( group_name, INSTR( group_name, p_delimiter, 1, (p_sequence-1))+1),
618: SUBSTR( group_name, (INSTR( group_name, p_delimiter, 1, (p_sequence-1))+1),
619: ( INSTR( group_name, p_delimiter, 1, p_sequence)
620: -(INSTR( group_name, p_delimiter, 1, (p_sequence-1))+1)))) meaning
621: FROM pay_people_groups
622: WHERE id_flex_num = p_id_flex_num
623: AND DECODE ( SUBSTR( p_type, 8 ),
624: 'SEGMENT1', segment1,
625: 'SEGMENT2', segment2,

Line 906: -- , pay_people_groups z

902: -- seg.id_flex_code= fl.id_flex_code AND
903: -- seg.id_flex_num = (
904: -- SELECT DISTINCT z.id_flex_num
905: -- FROM per_all_assignments_f asg
906: -- , pay_people_groups z
907: -- WHERE asg.people_group_id = z.people_group_id
908: -- AND asg.business_group_id = p_business_group_id ) AND
909: -- seg.display_flag = 'Y'
910: -- AND

Line 1178: FROM pay_people_groups grp

1174: cursor get_people_segment_value IS
1175: select SEGMENT1,SEGMENT2,SEGMENT3,SEGMENT4,SEGMENT5,SEGMENT6,SEGMENT7,SEGMENT8,SEGMENT9,SEGMENT10,
1176: SEGMENT11,SEGMENT12,SEGMENT13,SEGMENT14,SEGMENT15,SEGMENT16,SEGMENT17,SEGMENT18,SEGMENT19,SEGMENT20,
1177: SEGMENT21,SEGMENT22,SEGMENT23,SEGMENT24,SEGMENT25,SEGMENT26,SEGMENT27,SEGMENT28,SEGMENT29,SEGMENT30
1178: FROM pay_people_groups grp
1179: WHERE grp.people_group_id = p_flex_id;
1180:
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,