DBA Data[Home] [Help]

APPS.PAY_IE_SOE dependencies on PER_ALL_ASSIGNMENTS_F

Line 16: FROM per_all_assignments_f asg

12: p_payroll_action_id number;
13: p_date_earned varchar2(20);
14: CURSOR c_assignment IS
15: SELECT asg.assignment_id
16: FROM per_all_assignments_f asg
17: WHERE asg.person_id=p_person_id
18: AND p_effective_date between asg.effective_start_date and asg.effective_end_date;
19:
20: CURSOR c_action_id(a_asg_id number) IS

Line 78: ,per_all_assignments_f asg

74: ,pg.group_name COL08
75: ,asg.assignment_number COL09
76: ,peo.full_name COL10 --Removed Title for 4303921
77: from per_all_people_f peo
78: ,per_all_assignments_f asg
79: ,hr_all_organization_units_vl org
80: ,per_jobs_vl job
81: ,per_all_positions pos
82: ,hr_locations loc