eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ASN_BUS dependencies on PER_APPRAISALS

Line 1027: -- APPRAISAL_ID is a foreign key to the table PER_APPRAISALS.

1023: -- |--------------------------< CHK_APPRAISAL_ID >---------------------------|
1024: -- ----------------------------------------------------------------------------
1025: --
1026: -- DESCRIPTION
1027: -- APPRAISAL_ID is a foreign key to the table PER_APPRAISALS.
1028: -- If APPRAISAL_ID is NOT NULL, then the value must exist in the
1029: -- referenced table with the same business group.
1030: -- PRE-REQUISITES
1031: --

Line 1059: from per_appraisals

1055: -- Define the necessary cursor
1056: --
1057: cursor csr_chk_appraisal_id is
1058: select null
1059: from per_appraisals
1060: where appraisal_id = p_appraisal_id
1061: and business_group_id = p_business_group_id;
1062:
1063: l_exists varchar2(1);