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.GHR_UTILITY dependencies on PER_BUSINESS_GROUPS

Line 200: l_bus_group_id per_business_groups.business_group_id%TYPE;

196: TYPE t_pos_name_arr IS TABLE OF VARCHAR2(250) INDEX BY BINARY_INTEGER;
197: l_pos_name_arr t_pos_name_arr;
198: l_delimiter_index NUMBER;
199: l_ctr NUMBER;
200: l_bus_group_id per_business_groups.business_group_id%TYPE;
201:
202: BEGIN
203: l_index := 1;
204: fnd_profile.get('PER_BUSINESS_GROUP_ID',l_bus_group_id);

Line 309: l_bus_group_id per_business_groups.business_group_id%TYPE;

305: l_pos_new_title per_position_definitions.segment1%type;
306: l_pos_new_desc per_position_definitions.segment1%type;
307: l_ctr NUMBER;
308: l_flex_num NUMBER;
309: l_bus_group_id per_business_groups.business_group_id%TYPE;
310:
311: BEGIN
312: fnd_profile.get('PER_BUSINESS_GROUP_ID',l_bus_group_id);
313:

Line 757: per_business_groups.business_group_id%TYPE) is

753: where asg.assignment_id = p_assignment_id
754: and trunc(sysdate) between asg.effective_start_date
755: and asg.effective_end_date;
756: cursor cur_sec_grp(p_business_group_id in
757: per_business_groups.business_group_id%TYPE) is
758: select pbg.security_group_id
759: from per_business_groups pbg
760: where pbg.business_group_id = p_business_group_id;
761: v_current_sg NUMBER;

Line 759: from per_business_groups pbg

755: and asg.effective_end_date;
756: cursor cur_sec_grp(p_business_group_id in
757: per_business_groups.business_group_id%TYPE) is
758: select pbg.security_group_id
759: from per_business_groups pbg
760: where pbg.business_group_id = p_business_group_id;
761: v_current_sg NUMBER;
762: l_bus_group_id per_business_groups.business_group_id%TYPE;
763: l_security_group_id per_business_groups.security_group_id%TYPE;

Line 762: l_bus_group_id per_business_groups.business_group_id%TYPE;

758: select pbg.security_group_id
759: from per_business_groups pbg
760: where pbg.business_group_id = p_business_group_id;
761: v_current_sg NUMBER;
762: l_bus_group_id per_business_groups.business_group_id%TYPE;
763: l_security_group_id per_business_groups.security_group_id%TYPE;
764: begin
765: v_current_sg := fnd_profile.value('PER_SECURITY_PROFILE_ID');
766: IF v_current_sg is not null then

Line 763: l_security_group_id per_business_groups.security_group_id%TYPE;

759: from per_business_groups pbg
760: where pbg.business_group_id = p_business_group_id;
761: v_current_sg NUMBER;
762: l_bus_group_id per_business_groups.business_group_id%TYPE;
763: l_security_group_id per_business_groups.security_group_id%TYPE;
764: begin
765: v_current_sg := fnd_profile.value('PER_SECURITY_PROFILE_ID');
766: IF v_current_sg is not null then
767: -- We can assume that either: