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 722: l_assignment_id per_all_assignments_f.assignment_id%type;

718: l_plip_id ben_plip_f.plip_id%type;
719: l_oipl_id ben_oipl_f.oipl_id%type;
720: l_ler_id ben_ler_f.ler_id%type;
721: l_ptip_id ben_ptip_f.ptip_id%type;
722: l_assignment_id per_all_assignments_f.assignment_id%type;
723: l_exists boolean;
724: l_ovn number;
725: l_errbuf varchar2(2000);
726: l_retcode number;