DBA Data[Home] [Help]

APPS.PQH_GENERIC_HIERARCHY_PACKAGE dependencies on HR_LOOKUPS

Line 639: select 'x' from HR_LOOKUPS

635: -- Check if the lookup code exists already
636: -- for the lookup_type
637: --
638: CURSOR csr_lookup_code_unique IS
639: select 'x' from HR_LOOKUPS
640: where lookup_type = p_lookup_type
641: and lookup_code = p_lookup_code;
642: --
643: -- Check if the lookup meaning exists already

Line 647: select 'x' from HR_LOOKUPS

643: -- Check if the lookup meaning exists already
644: -- for the lookup_type
645: --
646: CURSOR csr_lookup_meaning_unique IS
647: select 'x' from HR_LOOKUPS
648: where lookup_type = p_lookup_type
649: and meaning = p_meaning;
650:
651: --