APPS.PER_PEOPLE12_PKG dependencies on PER_ASSIGNMENTS_F

Line 240: from per_assignments_f

236: select PAY_PROPOSAL_ID
237: from per_pay_proposals
238: where change_date = p_s_hire_date
239: and assignment_id = (select assignment_id
240: from per_assignments_f
241: where person_id = p_person_id
242: and primary_flag = 'Y'
243: and effective_start_date = p_hire_date
244: and assignment_type = 'E'

Line 1962: -- from per_assignments_f

1958: -- update per_pay_proposals
1959: -- set change_date = p_hire_date
1960: -- where change_date = p_s_hire_date
1961: -- and assignment_id = (select assignment_id
1962: -- from per_assignments_f
1963: -- where person_id = p_person_id
1964: -- and primary_flag = 'Y'
1965: -- and effective_start_date = p_hire_date
1966: -- and assignment_type = 'E'

Line 2580: from per_assignments_f

2576: select PAY_PROPOSAL_ID
2577: from per_pay_proposals
2578: where change_date = p_s_hire_date
2579: and assignment_id = (select assignment_id
2580: from per_assignments_f
2581: where person_id = p_person_id
2582: and primary_flag = 'Y'
2583: and effective_start_date = p_hire_date
2584: and assignment_type = 'E'

Line 3967: -- from per_assignments_f

3963: -- update per_pay_proposals
3964: -- set change_date = p_hire_date
3965: -- where change_date = p_s_hire_date
3966: -- and assignment_id = (select assignment_id
3967: -- from per_assignments_f
3968: -- where person_id = p_person_id
3969: -- and primary_flag = 'Y'
3970: -- and effective_start_date = p_hire_date
3971: -- and assignment_type = 'E'

Line 4129: from per_assignments_f paf

4125: --
4126: cursor supervisor
4127: is
4128: select 'Y'
4129: from per_assignments_f paf
4130: where paf.assignment_type = 'E'
4131: and paf.supervisor_id = p_person_id
4132: and p_new_hire_date > paf.effective_start_date
4133: and paf.effective_end_date >= p_old_hire_date ;

Line 4318: from per_assignments_f asg

4314: --
4315: cursor get_payroll
4316: is
4317: select asg.assignment_id
4318: from per_assignments_f asg
4319: where asg.person_id = p_person_id
4320: and asg.payroll_id is not null;
4321: begin
4322: open get_payroll;

Line 4368: from per_assignments_f asg

4364: pay_element_links_f el,
4365: pay_element_types_f et
4366: where ee.assignment_id in
4367: (select assignment_id
4368: from per_assignments_f asg
4369: where asg.person_id = p_person_id
4370: and asg.effective_start_date between l_earlier_date and l_later_date)
4371: and ee.element_link_id = el.element_link_id
4372: and el.element_type_id = et.element_type_id