APPS.PER_PTU_BUS dependencies on PER_PERSON_TYPES

Line 517: -- the parent PER_PERSON_TYPES table.

513: -- -----------------------------------------------------------------
514: --
515: -- Description:
516: -- Check that the person_type_id is not null and that it refers to a row on
517: -- the parent PER_PERSON_TYPES table.
518: -- Amendments to ensure that only valid person_types are inserted/updated
519: --
520: -- Pre-Requisites:
521: -- None

Line 549: l_person_type per_person_types.system_person_type%TYPE;

545: ) is
546: --
547: -- Local declarations
548: l_proc varchar2(72) := g_package||' chk_person_type_id';
549: l_person_type per_person_types.system_person_type%TYPE;
550: l_business_group_id per_person_types.business_group_id%TYPE;
551: l_old_person_type per_person_types.system_person_type%TYPE;
552: l_person_type_id number;
553: l_api_updating boolean;

Line 550: l_business_group_id per_person_types.business_group_id%TYPE;

546: --
547: -- Local declarations
548: l_proc varchar2(72) := g_package||' chk_person_type_id';
549: l_person_type per_person_types.system_person_type%TYPE;
550: l_business_group_id per_person_types.business_group_id%TYPE;
551: l_old_person_type per_person_types.system_person_type%TYPE;
552: l_person_type_id number;
553: l_api_updating boolean;
554: --

Line 551: l_old_person_type per_person_types.system_person_type%TYPE;

547: -- Local declarations
548: l_proc varchar2(72) := g_package||' chk_person_type_id';
549: l_person_type per_person_types.system_person_type%TYPE;
550: l_business_group_id per_person_types.business_group_id%TYPE;
551: l_old_person_type per_person_types.system_person_type%TYPE;
552: l_person_type_id number;
553: l_api_updating boolean;
554: --
555: -- Setup cursor for valid module type check

Line 560: from per_person_types

556: --
557: cursor csr_valid_person_type ( lc_person_type_id number)
558: is
559: select system_person_type ,business_group_id
560: from per_person_types
561: where person_type_id = lc_person_type_id;
562:
563: --
564: -- Setup cursor for combination check

Line 572: from per_person_types

568: cursor csr_check_uniqueness is
569: select person_type_usage_id
570: from per_person_type_usages_f
571: where person_type_id in ( select person_type_id
572: from per_person_types
573: where system_person_type = l_person_type
574: and business_group_id = l_business_group_id )
575: and person_id = p_person_id
576: and ((effective_start_date <= p_effective_date and