DBA Data[Home] [Help]

APPS.PER_PEOPLE_V14_PKG dependencies on PER_STARTUP_PERSON_TYPES

Line 69: , per_startup_person_types pst

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')
73: AND ppt.default_flag = 'Y'