APPS.PQH_RST_BUS dependencies on PER_ORGANIZATION_STRUCTURES

Line 631: l_business_group_id per_organization_structures.business_group_id%type;

627: --
628: l_proc varchar2(72) := g_package||'chk_organization_structure_id';
629: l_api_updating boolean;
630: l_dummy varchar2(1);
631: l_business_group_id per_organization_structures.business_group_id%type;
632:
633: --
634: cursor c1 is
635: select business_group_id

Line 636: from per_organization_structures a

632:
633: --
634: cursor c1 is
635: select business_group_id
636: from per_organization_structures a
637: where a.organization_structure_id = p_organization_structure_id;
638: --
639: Begin
640: --

Line 655: -- check if organization_structure_id value exists in per_organization_structures table

651: <> nvl(pqh_rst_shd.g_old_rec.organization_structure_id,hr_api.g_number))
652: or not l_api_updating) and
653: p_organization_structure_id is not null then
654: --
655: -- check if organization_structure_id value exists in per_organization_structures table
656: --
657: open c1;
658: --
659: fetch c1 into l_business_group_id;

Line 664: -- raise error as FK does not relate to PK in per_organization_structures

660: if c1%notfound then
661: --
662: close c1;
663: --
664: -- raise error as FK does not relate to PK in per_organization_structures
665: -- table.
666: --
667: pqh_rst_shd.constraint_error('PQH_RULE_SETS_FK2');
668: --