APPS.BEN_CWB_PERSON_INFO_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 23: from per_all_assignments_f paf

19: ,ppp.change_date) salary_currency
20: ,nvl(ppb.pay_annualization_factor,1) salary_ann_fctr
21: ,get_fte_factor(v_assignment_id
22: ,v_effective_date) fte_factor
23: from per_all_assignments_f paf
24: ,per_pay_proposals ppp
25: ,per_pay_bases ppb
26: where ppp.assignment_id = v_assignment_id
27: and ppp.approved = 'Y'

Line 158: from per_all_assignments_f asgjob

154: to_date('4712/12/31', 'yyyy/mm/dd'),p_effective_date,
155: least(asgjob.effective_end_date+1,p_effective_date)),
156: asgjob.effective_start_date))/12,1)
157: into l_years_in_job
158: from per_all_assignments_f asgjob
159: where asgjob.assignment_id=p_assignment_id
160: and asgjob.job_id = p_job_id
161: and asgjob.effective_start_date <= p_asg_effective_start_date
162: and asgjob.assignment_type in ('C','E'); -- bug 13061653

Line 197: from per_all_assignments_f asgpos

193: to_date('4712/12/31', 'yyyy/mm/dd'),p_effective_date,
194: least(asgpos.effective_end_date+1,p_effective_date)),
195: asgpos.effective_start_date))/12,1)
196: into l_years_in_position
197: from per_all_assignments_f asgpos
198: where asgpos.assignment_id=p_assignment_id
199: and asgpos.position_id = p_position_id
200: and asgpos.effective_start_date <= p_asg_effective_start_date;
201: --

Line 235: from per_all_assignments_f asggrd

231: to_date('4712/12/31', 'yyyy/mm/dd'),p_effective_date,
232: least(asggrd.effective_end_date+1,p_effective_date)),
233: asggrd.effective_start_date))/12,1)
234: into l_years_in_grade
235: from per_all_assignments_f asggrd
236: where asggrd.assignment_id=p_assignment_id
237: and asggrd.grade_id = p_grade_id
238: and asggrd.effective_start_date <= p_asg_effective_start_date
239: and asggrd.assignment_type <> 'A'; --9060804

Line 657: ,per_all_assignments_f paf

653: WHERE appraisee_person_id = ppf.person_id
654: AND event_id = perf.event_id)
655: END ) appraisal_id
656: from per_all_people_f ppf
657: ,per_all_assignments_f paf
658: ,ben_per_in_ler pil
659: ,per_all_people_f supv
660: ,per_all_assignments_f supv_asg
661: ,hr_organization_information bg

Line 660: ,per_all_assignments_f supv_asg

656: from per_all_people_f ppf
657: ,per_all_assignments_f paf
658: ,ben_per_in_ler pil
659: ,per_all_people_f supv
660: ,per_all_assignments_f supv_asg
661: ,hr_organization_information bg
662: ,hr_organization_information supv_bg
663: ,per_periods_of_service service_period
664: ,per_pay_proposals ppp

Line 681: ,per_all_assignments_f paf_prev

677: and nvl(evt1.type, '-X-X-X-') = nvl(l_performance_rating_type, '-X-X-X-')
678: ) perf
679: ,per_pay_bases ppb
680: ,pay_people_groups grp
681: ,per_all_assignments_f paf_prev
682: ,per_pay_proposals ppp_prev
683: ,per_pay_bases ppb_prev
684: where pil.per_in_ler_id = p_group_per_in_ler_id
685: and paf.assignment_id = pil.assignment_id

Line 1905: from per_all_assignments_f asg,

1901: SELECT
1902: decode(g_fte_factor,
1903: 'NHBGWH',(select normal_hours /decode(fnd_number.canonical_to_number(working_hours), 0, to_number(NULL)
1904: ,fnd_number.canonical_to_number(working_hours))
1905: from per_all_assignments_f asg,
1906: per_business_groups bg
1907: where asg.assignment_id = p_assignment_id
1908: and asg.business_group_id = bg.business_group_id
1909: and p_effective_date BETWEEN effective_start_date AND effective_end_date),