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_REI_BUS dependencies on PER_BUSINESS_GROUPS

Line 29: from per_business_groups pbg

25: -- Declare cursor
26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , per_contact_relationships pcr
31: where pcr.contact_relationship_id = p_contact_relationship_id
32: AND pbg.business_group_id = pcr.business_group_id;
33: --

Line 92: -- per_contact_extra_info_f and PER_BUSINESS_GROUPS

88: --
89: -- Declare cursor
90: --
91: -- EDIT_HERE In the following cursor statement add join(s) between
92: -- per_contact_extra_info_f and PER_BUSINESS_GROUPS
93: -- so that the legislation_code for
94: -- the current business group context can be derived.
95: -- Remove this comment when the edit has been completed.
96: cursor csr_leg_code is

Line 98: from per_business_groups_perf pbg

94: -- the current business group context can be derived.
95: -- Remove this comment when the edit has been completed.
96: cursor csr_leg_code is
97: select pbg.legislation_code
98: from per_business_groups_perf pbg
99: , per_contact_relationships ctr
100: , per_contact_extra_info_f cei
101: where cei.contact_extra_info_id = p_contact_extra_info_id
102: and ctr.contact_relationship_id = cei.contact_relationship_id