DBA Data[Home] [Help]

APPS.PER_PERSON_TYPES_PKG dependencies on PER_BUSINESS_GROUPS

Line 503: from per_business_groups org

499: (x_name in hr_all_organization_units.name%TYPE
500: )
501: is
502: select org.organization_id
503: from per_business_groups org
504: where org.name = x_name;
505: l_business_group csr_business_group%ROWTYPE;
506: cursor csr_person_type
507: (x_user_person_type in per_person_types.user_person_type%TYPE

Line 571: ,per_business_groups org

567: )
568: is
569: select ptp.person_type_id
570: from per_person_types ptp
571: ,per_business_groups org
572: where ptp.business_group_id = org.organization_id
573: and ptp.user_person_type = x_user_person_type
574: and org.name = x_name;
575: l_person_type csr_person_type%ROWTYPE;