APPS.HR_PFT_BUS dependencies on PER_BUSINESS_GROUPS

Line 29: -- hr_all_positions_f_tl and PER_BUSINESS_GROUPS

25: --
26: -- Declare cursor
27: --
28: -- EDIT_HERE In the following cursor statement add join(s) between
29: -- hr_all_positions_f_tl and PER_BUSINESS_GROUPS
30: -- so that the security_group_id for
31: -- the current business group context can be derived.
32: -- Remove this comment when the edit has been completed.
33: /*cursor csr_sec_grp is

Line 35: from per_business_groups pbg

31: -- the current business group context can be derived.
32: -- Remove this comment when the edit has been completed.
33: /*cursor csr_sec_grp is
34: select pbg.security_group_id
35: from per_business_groups pbg
36: , hr_all_positions_f_tl pft
37: -- , EDIT_HERE table_name(s) 333
38: where pft.position_id = p_position_id; */
39: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 46: from per_business_groups pbg

42: -- cursor modified to improve performance.
43:
44: cursor csr_sec_grp is
45: select pbg.security_group_id
46: from per_business_groups pbg
47: ,hr_all_positions_f_tl pft
48: ,hr_all_positions_f pf
49: where pf.position_id =p_position_id
50: and pft.position_id = pf.position_id

Line 115: -- hr_all_positions_f_tl and PER_BUSINESS_GROUPS

111: --
112: -- Declare cursor
113: --
114: -- EDIT_HERE In the following cursor statement add join(s) between
115: -- hr_all_positions_f_tl and PER_BUSINESS_GROUPS
116: -- so that the legislation_code for
117: -- the current business group context can be derived.
118: -- Remove this comment when the edit has been completed.
119: cursor csr_leg_code is

Line 121: from per_business_groups pbg

117: -- the current business group context can be derived.
118: -- Remove this comment when the edit has been completed.
119: cursor csr_leg_code is
120: select pbg.legislation_code
121: from per_business_groups pbg
122: , hr_all_positions_f_tl pft
123: , hr_positions_f pof
124: where pft.position_id = p_position_id
125: and pft.language = p_language