APPS.HR_CANCEL_HIRE_API dependencies on PER_PERSON_TYPE_USAGES_F

Line 134: from per_person_type_usages_f ppf1

130:
131: cursor csr_emp_apl_chk is
132:
133: select max(effective_start_date)
134: from per_person_type_usages_f ppf1
135: where ppf1.person_id = p_person_id
136:
137: and ppf1.effective_start_date >
138: ( select max(ppf2.effective_start_date)

Line 139: from per_person_type_usages_f ppf2 , per_person_types ppt2

135: where ppf1.person_id = p_person_id
136:
137: and ppf1.effective_start_date >
138: ( select max(ppf2.effective_start_date)
139: from per_person_type_usages_f ppf2 , per_person_types ppt2
140: where ppf2.person_id = p_person_id
141: and ppt2.person_type_id= ppf2.person_type_id
142: and ppt2.system_person_type='APL'
143: and ppt2.business_group_id = l_business_group_id )

Line 154: per_person_type_usages_f ppf2

150: and ppt.business_group_id = l_business_group_id )
151:
152: and not exists (
153: select '1' from
154: per_person_type_usages_f ppf2
155: where ppf2.person_id = p_person_id
156: and ppf2.effective_start_date > ppf1.effective_start_date
157: and ppf2.person_type_id <> ppf1.person_type_id ); -- fix for 9587362
158:

Line 161: from per_person_type_usages_f pptf

157: and ppf2.person_type_id <> ppf1.person_type_id ); -- fix for 9587362
158:
159: cursor csr_rehired_date is
160: select max(effective_start_date)
161: from per_person_type_usages_f pptf
162: where person_id = p_person_id
163: and exists (
164: select '1' from
165: per_person_types ppt

Line 172: from per_person_type_usages_f pptf

168: and ppt.business_group_id = l_business_group_id );
169:
170: cursor csr_apl_date is
171: select max(effective_start_date)
172: from per_person_type_usages_f pptf
173: where person_id = p_person_id
174: and exists (
175: select '1' from
176: per_person_types ppt

Line 189: ,per_person_type_usages_f ptu

185: )
186: IS
187: SELECT typ.system_person_type
188: FROM per_person_types typ
189: ,per_person_type_usages_f ptu
190: WHERE
191: typ.system_person_type IN ('APL','EMP','EX_APL','EX_EMP','CWK','EX_CWK','OTHER')
192: AND typ.person_type_id = ptu.person_type_id
193: AND p_effective_date BETWEEN ptu.effective_start_date

Line 208: from per_person_type_usages_f where

204: );
205:
206: cursor csr_fut_person_check (l_date date) is
207: select '1'
208: from per_person_type_usages_f where
209: person_id=p_person_id and
210: effective_start_date > l_date;
211:
212: l_efd date :=null;

Line 373: -- be deleted from the per_person_type_usages_f when

369: -- code added by sathkris for the bug 8504597 starts here
370: -- when cancelled the hire for an employe.exapplicant whose
371: -- previos person type was ex employee revert the previous
372: -- person type to ex employee(since the ex employee record will
373: -- be deleted from the per_person_type_usages_f when
374: -- hiring the applicant on the imm next day of terminating him)
375: -- so person type EX_EMP has been hard coded
376:
377: open csr_chk_prds_of_ser