DBA Data[Home] [Help]

APPS.PER_PEOPLE_V14_PKG dependencies on PER_STARTUP_PERSON_TYPES

Line 75: , per_startup_person_types pst

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