APPS.GHR_GENERAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 82: from per_all_assignments_f asg

78:
79:
80: cursor get_position_id is
81: select asg.position_id
82: from per_all_assignments_f asg
83: where asg.person_id = l_person_id
84: and l_effective_date between asg.effective_start_date and asg.effective_end_date
85: and asg.assignment_type <> 'B';
86:

Line 92: l_position_id per_all_assignments_f.position_id%type;

88: select fnd.user_name
89: from fnd_user fnd
90: where l_gbx_user_id = fnd.employee_id;
91:
92: l_position_id per_all_assignments_f.position_id%type;
93:
94: begin
95:
96: hr_utility.set_location('Entering' ,1);

Line 710: l_assignment_id per_all_assignments_f.assignment_id%type;

706: l_plip_id ben_plip_f.plip_id%type;
707: l_oipl_id ben_oipl_f.oipl_id%type;
708: l_ler_id ben_ler_f.ler_id%type;
709: l_ptip_id ben_ptip_f.ptip_id%type;
710: l_assignment_id per_all_assignments_f.assignment_id%type;
711: l_exists boolean;
712: l_ovn number;
713: l_errbuf varchar2(2000);
714: l_retcode number;