APPS.PER_ASN_BUS dependencies on PER_ASSESSMENT_GROUPS

Line 942: -- ASSESSMENT_GROUP is a foreign key to the table PER_ASSESSMENT_GROUPS.

938: -- |-----------------------< CHK_ASSESSMENT_GROUP_ID >------------------------|
939: -- ----------------------------------------------------------------------------
940: --
941: -- DESCRIPTION
942: -- ASSESSMENT_GROUP is a foreign key to the table PER_ASSESSMENT_GROUPS.
943: -- If ASSESSMENT_GROUP is NOT NULL, then the value must exist in the
944: -- referenced table with the same business group.
945: -- PRE-REQUISITES
946: --

Line 973: from per_assessment_groups

969: -- Define the necessary cursor
970: --
971: cursor csr_chk_ass_group_id is
972: select null
973: from per_assessment_groups
974: where assessment_group_id = p_assessment_group_id
975: and business_group_id = p_business_group_Id;
976:
977: l_exists varchar2(1);