APPS.HRHIRAPL dependencies on PER_APPLICATIONS

Line 714: update per_applications pap

710: -- the fact the table does not have stored a retain value .
711: --
712: hr_utility.set_location('hrhiapl.make_secondary',2);
713: --
714: update per_applications pap
715: set date_end = p_start_date -1,
716: successful_flag = 'Y'
717: where pap.person_id = p_person_id -- added for bug 5469726
718: and exists (select '1'

Line 1172: from per_applications

1168:
1169:
1170: cursor appl_rec_det(l_appl_id number) is
1171: select projected_hire_date
1172: from per_applications
1173: where application_id =l_appl_id;
1174:
1175:
1176:

Line 2874: from per_applications

2870: l_date_probation_end date;
2871:
2872: cursor appl_rec_det1(l_appl_id number) is
2873: select projected_hire_date
2874: from per_applications
2875: where application_id =l_appl_id;
2876:
2877: --7120387
2878: --

Line 4153: from per_applications

4149: and effective_end_date;
4150:
4151: cursor appl_rec_det(l_appl_id number) is
4152: select projected_hire_date
4153: from per_applications
4154: where application_id =l_appl_id;
4155:
4156: l_date_probation_end date;
4157: l_proj_hire_date date;