APPS.PER_PEOPLE_V14_PKG dependencies on PER_PERSON_TYPES

Line 68: FROM per_person_types ppt

64: , pst.current_applicant_flag
65: , pst.current_emp_or_apl_flag
66: , TRUNC(SYSDATE)
67: , TO_DATE('31/12/4712','DD/MM/YYYY')
68: FROM per_person_types ppt
69: , per_startup_person_types pst
70: WHERE ppt.business_group_id = X_Business_group_id -- Bug 3648460
71: AND ppt.system_person_type = pst.system_person_type
72: AND ppt.system_person_type = DECODE(X_current_appl_id,810,'OTHER','EMP')

Line 230: -- Get the Default Employee Person_type from Per_Person_types

226: OPEN expense_address;
227: FETCH expense_address INTO X_expense_to_address_meaning;
228: CLOSE expense_address;
229: --
230: -- Get the Default Employee Person_type from Per_Person_types
231: -- and the start and end dates for a row entered as of sysdate.
232: --
233: OPEN person_type;
234: FETCH person_type INTO X_person_type_id,X_current_employee_flag