APPS.PER_PEOPLE_V14_PKG dependencies on PER_PERSON_TYPES

Line 74: FROM per_person_types ppt

70: , pst.current_applicant_flag
71: , pst.current_emp_or_apl_flag
72: , TRUNC(SYSDATE)
73: , TO_DATE('31/12/4712','DD/MM/YYYY')
74: FROM per_person_types ppt
75: , per_startup_person_types pst
76: WHERE ppt.business_group_id = X_Business_group_id -- Bug 3648460
77: AND ppt.system_person_type = pst.system_person_type
78: AND ppt.system_person_type = DECODE(X_current_appl_id,810,'OTHER','EMP')

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

253: OPEN expense_address;
254: FETCH expense_address INTO X_expense_to_address_meaning;
255: CLOSE expense_address;
256: --
257: -- Get the Default Employee Person_type from Per_Person_types
258: -- and the start and end dates for a row entered as of sysdate.
259: --
260: OPEN person_type;
261: FETCH person_type INTO X_person_type_id,X_current_employee_flag