DBA Data[Home] [Help]

APPS.PQH_ASG_WRAPPER dependencies on HR_ORGANIZATION_UNITS

Line 541: (p_search_org_id IN hr_organization_units.organization_id%TYPE

537: -- |------------------------------< IS_ORG_A_NODE >---------------------------+
538: -- ---------------------------------------------------------------------------+
539: --
540: FUNCTION Is_Org_A_Node
541: (p_search_org_id IN hr_organization_units.organization_id%TYPE
542: ,p_organization_structure_id IN per_org_structure_versions_v.organization_structure_id%TYPE)
543: RETURN CHAR IS
544: --
545: Cursor c_get_structure_version Is

Line 627: (p_search_org_id IN hr_organization_units.organization_id%TYPE)

623: -- |-------------------------< IS_ORG_IN_HIERARCHY >--------------------------+
624: -- ---------------------------------------------------------------------------+
625: --
626: FUNCTION Is_Org_In_Hierarchy
627: (p_search_org_id IN hr_organization_units.organization_id%TYPE)
628: RETURN CHAR IS
629: --
630: Cursor c_is_field_populated Is
631: Select to_number(information2),