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_PEA_BUS dependencies on PER_PEOPLE_F

Line 19: -- Validates that values enterd for this column exist in the PER_PEOPLE_F

15: -- Desciption :
16: --
17: -- Validates that PERSON_ID is not null
18: --
19: -- Validates that values enterd for this column exist in the PER_PEOPLE_F
20: -- table.
21: --
22: -- Validates that BUSINESS_GROUP_ID in the PER_PERSON_ANALYSES table matches
23: -- BUSINESS_GROUP_ID in the PER_PEOPLE_F table for the record specified by

Line 23: -- BUSINESS_GROUP_ID in the PER_PEOPLE_F table for the record specified by

19: -- Validates that values enterd for this column exist in the PER_PEOPLE_F
20: -- table.
21: --
22: -- Validates that BUSINESS_GROUP_ID in the PER_PERSON_ANALYSES table matches
23: -- BUSINESS_GROUP_ID in the PER_PEOPLE_F table for the record specified by
24: -- PERSON_ID.
25: --
26: -- Pre-conditions:
27: --

Line 60: from per_people_f per

56: -- the BUSINESS_GROUP_ID for the other validation checks
57: --
58: cursor csr_valid_person_id is
59: select per.business_group_id
60: from per_people_f per
61: where per.person_id = p_person_id
62: and p_effective_date between per.effective_start_date
63: and per.effective_end_date;
64: --