DBA Data[Home] [Help]

APPS.PER_PERSON_TYPES_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 499: (x_name in hr_all_organization_units.name%TYPE

495: ,X_OWNER in VARCHAR2
496: )
497: is
498: cursor csr_business_group
499: (x_name in hr_all_organization_units.name%TYPE
500: )
501: is
502: select org.organization_id
503: from per_business_groups org

Line 566: ,x_name in hr_all_organization_units.name%TYPE

562: )
563: is
564: cursor csr_person_type
565: (x_user_person_type in per_person_types.user_person_type%TYPE
566: ,x_name in hr_all_organization_units.name%TYPE
567: )
568: is
569: select ptp.person_type_id
570: from per_person_types ptp