APPS.HRENTMNT dependencies on PAY_PEOPLE_GROUPS

Line 433: pay_people_groups ppg

429: asg.effective_end_date,
430: asg.people_group_id,
431: ppg.id_flex_num
432: from per_all_assignments_f asg,
433: pay_people_groups ppg
434: where asg.assignment_id = p_assignment_id
435: and asg.people_group_id is not null
436: and asg.assignment_type not in ('A' ,'O') -- non-applicant assignments only
437: and ppg.people_group_id = asg.people_group_id

Line 454: pay_people_groups el_pg,

450: select el.element_link_id,
451: min(el.effective_start_date) effective_start_date,
452: max(el.effective_end_date) effective_end_date
453: from pay_element_links_f el,
454: pay_people_groups el_pg,
455: pay_people_groups asg_pg
456: where asg_pg.id_flex_num = p_id_flex_num
457: and asg_pg.people_group_id = p_people_group_id
458: and el_pg.id_flex_num = asg_pg.id_flex_num

Line 455: pay_people_groups asg_pg

451: min(el.effective_start_date) effective_start_date,
452: max(el.effective_end_date) effective_end_date
453: from pay_element_links_f el,
454: pay_people_groups el_pg,
455: pay_people_groups asg_pg
456: where asg_pg.id_flex_num = p_id_flex_num
457: and asg_pg.people_group_id = p_people_group_id
458: and el_pg.id_flex_num = asg_pg.id_flex_num
459: and el.business_group_id + 0 = p_business_group_id

Line 6633: -- The min value of the pay_people_groups_s sequence is 1, so setting

6629: -- maintained for applicants. Therefore, even if the old and new people
6630: -- group ids are the same, the ALUs won't have been built previously.
6631: -- In order to force a rebuild of the ALUs, the old and new people group
6632: -- ids must differ. We modify the old people group id to ensure this.
6633: -- The min value of the pay_people_groups_s sequence is 1, so setting
6634: -- p_old_people_group_id to 0 will guarantee the old and new people group
6635: -- ids will always differ.
6636: --
6637: hrentmnt.adjust_entries_asg_criteria