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 210: l_bus_group_id per_business_groups.business_group_id%TYPE;

206: TYPE t_pos_name_arr IS TABLE OF VARCHAR2(250) INDEX BY BINARY_INTEGER;
207: l_pos_name_arr t_pos_name_arr;
208: l_delimiter_index NUMBER;
209: l_ctr NUMBER;
210: l_bus_group_id per_business_groups.business_group_id%TYPE;
211:
212: BEGIN
213: l_index := 1;
214: fnd_profile.get('PER_BUSINESS_GROUP_ID',l_bus_group_id);

Line 319: l_bus_group_id per_business_groups.business_group_id%TYPE;

315: l_pos_new_title per_position_definitions.segment1%type;
316: l_pos_new_desc per_position_definitions.segment1%type;
317: l_ctr NUMBER;
318: l_flex_num NUMBER;
319: l_bus_group_id per_business_groups.business_group_id%TYPE;
320:
321: BEGIN
322: fnd_profile.get('PER_BUSINESS_GROUP_ID',l_bus_group_id);
323:

Line 774: per_business_groups.business_group_id%TYPE) is

770: where asg.assignment_id = p_assignment_id
771: and trunc(sysdate) between asg.effective_start_date
772: and asg.effective_end_date;
773: cursor cur_sec_grp(p_business_group_id in
774: per_business_groups.business_group_id%TYPE) is
775: select pbg.security_group_id
776: from per_business_groups pbg
777: where pbg.business_group_id = p_business_group_id;
778: v_current_sg NUMBER;

Line 776: from per_business_groups pbg

772: and asg.effective_end_date;
773: cursor cur_sec_grp(p_business_group_id in
774: per_business_groups.business_group_id%TYPE) is
775: select pbg.security_group_id
776: from per_business_groups pbg
777: where pbg.business_group_id = p_business_group_id;
778: v_current_sg NUMBER;
779: l_bus_group_id per_business_groups.business_group_id%TYPE;
780: l_security_group_id per_business_groups.security_group_id%TYPE;

Line 779: l_bus_group_id per_business_groups.business_group_id%TYPE;

775: select pbg.security_group_id
776: from per_business_groups pbg
777: where pbg.business_group_id = p_business_group_id;
778: v_current_sg NUMBER;
779: l_bus_group_id per_business_groups.business_group_id%TYPE;
780: l_security_group_id per_business_groups.security_group_id%TYPE;
781: begin
782: v_current_sg := fnd_profile.value('PER_SECURITY_PROFILE_ID');
783: IF v_current_sg is not null then

Line 780: l_security_group_id per_business_groups.security_group_id%TYPE;

776: from per_business_groups pbg
777: where pbg.business_group_id = p_business_group_id;
778: v_current_sg NUMBER;
779: l_bus_group_id per_business_groups.business_group_id%TYPE;
780: l_security_group_id per_business_groups.security_group_id%TYPE;
781: begin
782: v_current_sg := fnd_profile.value('PER_SECURITY_PROFILE_ID');
783: IF v_current_sg is not null then
784: -- We can assume that either: