APPS.PER_PERSON_TYPES_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 117: p_ref_entity => 'HR_ALL_ORGANIZATION_UNITS',

113:
114: BEGIN
115: PER_RIC_PKG.chk_integrity (
116: p_entity_name => 'PER_PERSON_TYPES',
117: p_ref_entity => 'HR_ALL_ORGANIZATION_UNITS',
118: p_ref_column_name => 'BUSINESS_GROUP_ID',
119: p_ref_col_value_number => X_BUSINESS_GROUP_ID,
120: p_ref_col_value_varchar => NULL,
121: p_ref_col_value_date => NULL,

Line 561: (x_name in hr_all_organization_units.name%TYPE

557: ,X_OWNER in VARCHAR2
558: )
559: is
560: cursor csr_business_group
561: (x_name in hr_all_organization_units.name%TYPE
562: )
563: is
564: select org.organization_id
565: from per_business_groups org

Line 628: ,x_name in hr_all_organization_units.name%TYPE

624: )
625: is
626: cursor csr_person_type
627: (x_user_person_type in per_person_types.user_person_type%TYPE
628: ,x_name in hr_all_organization_units.name%TYPE
629: )
630: is
631: select ptp.person_type_id
632: from per_person_types ptp