APPS.PER_PEOPLE12_PKG dependencies on PER_ASSIGNMENTS_F

Line 566: from per_assignments_f

562: select PAY_PROPOSAL_ID
563: from per_pay_proposals
564: where change_date = p_s_hire_date
565: and assignment_id = (select assignment_id
566: from per_assignments_f
567: where person_id = p_person_id
568: and primary_flag = 'Y'
569: and effective_start_date = p_hire_date
570: and assignment_type = 'E'

Line 1685: -- from per_assignments_f

1681: -- update per_pay_proposals
1682: -- set change_date = p_hire_date
1683: -- where change_date = p_s_hire_date
1684: -- and assignment_id = (select assignment_id
1685: -- from per_assignments_f
1686: -- where person_id = p_person_id
1687: -- and primary_flag = 'Y'
1688: -- and effective_start_date = p_hire_date
1689: -- and assignment_type = 'E'

Line 1806: from per_assignments_f paf

1802: --
1803: cursor supervisor
1804: is
1805: select 'Y'
1806: from per_assignments_f paf
1807: where paf.assignment_type = 'E'
1808: and paf.supervisor_id = p_person_id
1809: and p_new_hire_date > paf.effective_start_date
1810: and paf.effective_end_date >= p_old_hire_date ;

Line 1995: from per_assignments_f asg

1991: --
1992: cursor get_payroll
1993: is
1994: select asg.assignment_id
1995: from per_assignments_f asg
1996: where asg.person_id = p_person_id
1997: and asg.payroll_id is not null;
1998: begin
1999: open get_payroll;

Line 2045: from per_assignments_f asg

2041: pay_element_links_f el,
2042: pay_element_types_f et
2043: where ee.assignment_id in
2044: (select assignment_id
2045: from per_assignments_f asg
2046: where asg.person_id = p_person_id
2047: and asg.effective_start_date between l_earlier_date and l_later_date)
2048: and ee.element_link_id = el.element_link_id
2049: and el.element_type_id = et.element_type_id