DBA Data[Home] [Help]

APPS.PER_PERSON_TYPES_PKG dependencies on PER_BUSINESS_GROUPS

Line 565: from per_business_groups org

561: (x_name in hr_all_organization_units.name%TYPE
562: )
563: is
564: select org.organization_id
565: from per_business_groups org
566: where org.name = x_name;
567: l_business_group csr_business_group%ROWTYPE;
568: cursor csr_person_type
569: (x_user_person_type in per_person_types.user_person_type%TYPE

Line 633: ,per_business_groups org

629: )
630: is
631: select ptp.person_type_id
632: from per_person_types ptp
633: ,per_business_groups org
634: where ptp.business_group_id = org.organization_id
635: and ptp.user_person_type = x_user_person_type
636: and org.name = x_name;
637: l_person_type csr_person_type%ROWTYPE;