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 153: from per_all_assignments_f asgjob

149: to_date('4712/12/31', 'yyyy/mm/dd'),p_effective_date,
150: least(asgjob.effective_end_date+1,p_effective_date)),
151: asgjob.effective_start_date))/12,1)
152: into l_years_in_job
153: from per_all_assignments_f asgjob
154: where asgjob.assignment_id=p_assignment_id
155: and asgjob.job_id = p_job_id
156: and asgjob.effective_start_date <= p_asg_effective_start_date;
157: --

Line 191: from per_all_assignments_f asgpos

187: to_date('4712/12/31', 'yyyy/mm/dd'),p_effective_date,
188: least(asgpos.effective_end_date+1,p_effective_date)),
189: asgpos.effective_start_date))/12,1)
190: into l_years_in_position
191: from per_all_assignments_f asgpos
192: where asgpos.assignment_id=p_assignment_id
193: and asgpos.position_id = p_position_id
194: and asgpos.effective_start_date <= p_asg_effective_start_date;
195: --

Line 229: from per_all_assignments_f asggrd

225: to_date('4712/12/31', 'yyyy/mm/dd'),p_effective_date,
226: least(asggrd.effective_end_date+1,p_effective_date)),
227: asggrd.effective_start_date))/12,1)
228: into l_years_in_grade
229: from per_all_assignments_f asggrd
230: where asggrd.assignment_id=p_assignment_id
231: and asggrd.grade_id = p_grade_id
232: and asggrd.effective_start_date <= p_asg_effective_start_date;
233: --

Line 634: ,per_all_assignments_f paf

630: ,ppp_prev.change_date) prev_fte_factor
631: ,ppp.pay_proposal_id current_pay_proposal_id
632: ,perf.appraisal_id appraisal_id
633: from per_all_people_f ppf
634: ,per_all_assignments_f paf
635: ,ben_per_in_ler pil
636: ,per_all_people_f supv
637: ,per_all_assignments_f supv_asg
638: ,hr_organization_information bg

Line 637: ,per_all_assignments_f supv_asg

633: from per_all_people_f ppf
634: ,per_all_assignments_f paf
635: ,ben_per_in_ler pil
636: ,per_all_people_f supv
637: ,per_all_assignments_f supv_asg
638: ,hr_organization_information bg
639: ,hr_organization_information supv_bg
640: ,per_periods_of_service service_period
641: ,per_pay_proposals ppp

Line 656: ,per_all_assignments_f paf_prev

652: and nvl(evt1.type, '-X-X-X-') = nvl(l_performance_rating_type, '-X-X-X-')
653: and evt1.event_id = apr.event_id(+)) perf
654: ,per_pay_bases ppb
655: ,pay_people_groups grp
656: ,per_all_assignments_f paf_prev
657: ,per_pay_proposals ppp_prev
658: ,per_pay_bases ppb_prev
659: where pil.per_in_ler_id = p_group_per_in_ler_id
660: and paf.assignment_id = pil.assignment_id

Line 1844: from per_all_assignments_f asg,

1840: SELECT
1841: decode(g_fte_factor,
1842: 'NHBGWH',(select normal_hours /decode(fnd_number.canonical_to_number(working_hours), 0, to_number(NULL)
1843: ,fnd_number.canonical_to_number(working_hours))
1844: from per_all_assignments_f asg,
1845: per_business_groups bg
1846: where asg.assignment_id = p_assignment_id
1847: and asg.business_group_id = bg.business_group_id
1848: and p_effective_date BETWEEN effective_start_date AND effective_end_date),