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.HR_FORM_ITEM_INFO dependencies on HR_FORM_ITEMS_B

Line 111: -- hr_form_items_b vp5

107: ,itp.information28
108: ,itp.information29
109: ,itp.information30
110: FROM
111: -- hr_form_items_b vp5
112: -- ,hr_form_items_b vp4
113: -- ,hr_form_items_b vp3
114: -- ,hr_form_items_b vp2
115: -- ,hr_form_items_b vp1

Line 112: -- ,hr_form_items_b vp4

108: ,itp.information29
109: ,itp.information30
110: FROM
111: -- hr_form_items_b vp5
112: -- ,hr_form_items_b vp4
113: -- ,hr_form_items_b vp3
114: -- ,hr_form_items_b vp2
115: -- ,hr_form_items_b vp1
116: -- ,hr_form_items_b ip5

Line 113: -- ,hr_form_items_b vp3

109: ,itp.information30
110: FROM
111: -- hr_form_items_b vp5
112: -- ,hr_form_items_b vp4
113: -- ,hr_form_items_b vp3
114: -- ,hr_form_items_b vp2
115: -- ,hr_form_items_b vp1
116: -- ,hr_form_items_b ip5
117: -- ,hr_form_items_b ip4

Line 114: -- ,hr_form_items_b vp2

110: FROM
111: -- hr_form_items_b vp5
112: -- ,hr_form_items_b vp4
113: -- ,hr_form_items_b vp3
114: -- ,hr_form_items_b vp2
115: -- ,hr_form_items_b vp1
116: -- ,hr_form_items_b ip5
117: -- ,hr_form_items_b ip4
118: -- ,hr_form_items_b ip3

Line 115: -- ,hr_form_items_b vp1

111: -- hr_form_items_b vp5
112: -- ,hr_form_items_b vp4
113: -- ,hr_form_items_b vp3
114: -- ,hr_form_items_b vp2
115: -- ,hr_form_items_b vp1
116: -- ,hr_form_items_b ip5
117: -- ,hr_form_items_b ip4
118: -- ,hr_form_items_b ip3
119: -- ,hr_form_items_b ip2

Line 116: -- ,hr_form_items_b ip5

112: -- ,hr_form_items_b vp4
113: -- ,hr_form_items_b vp3
114: -- ,hr_form_items_b vp2
115: -- ,hr_form_items_b vp1
116: -- ,hr_form_items_b ip5
117: -- ,hr_form_items_b ip4
118: -- ,hr_form_items_b ip3
119: -- ,hr_form_items_b ip2
120: -- ,hr_form_items_b ip1

Line 117: -- ,hr_form_items_b ip4

113: -- ,hr_form_items_b vp3
114: -- ,hr_form_items_b vp2
115: -- ,hr_form_items_b vp1
116: -- ,hr_form_items_b ip5
117: -- ,hr_form_items_b ip4
118: -- ,hr_form_items_b ip3
119: -- ,hr_form_items_b ip2
120: -- ,hr_form_items_b ip1
121: hr_form_tab_pages_b ftp

Line 118: -- ,hr_form_items_b ip3

114: -- ,hr_form_items_b vp2
115: -- ,hr_form_items_b vp1
116: -- ,hr_form_items_b ip5
117: -- ,hr_form_items_b ip4
118: -- ,hr_form_items_b ip3
119: -- ,hr_form_items_b ip2
120: -- ,hr_form_items_b ip1
121: hr_form_tab_pages_b ftp
122: ,hr_form_canvases_b fcn

Line 119: -- ,hr_form_items_b ip2

115: -- ,hr_form_items_b vp1
116: -- ,hr_form_items_b ip5
117: -- ,hr_form_items_b ip4
118: -- ,hr_form_items_b ip3
119: -- ,hr_form_items_b ip2
120: -- ,hr_form_items_b ip1
121: hr_form_tab_pages_b ftp
122: ,hr_form_canvases_b fcn
123: ,hr_form_items_b fim

Line 120: -- ,hr_form_items_b ip1

116: -- ,hr_form_items_b ip5
117: -- ,hr_form_items_b ip4
118: -- ,hr_form_items_b ip3
119: -- ,hr_form_items_b ip2
120: -- ,hr_form_items_b ip1
121: hr_form_tab_pages_b ftp
122: ,hr_form_canvases_b fcn
123: ,hr_form_items_b fim
124: ,hr_item_properties_b itp

Line 123: ,hr_form_items_b fim

119: -- ,hr_form_items_b ip2
120: -- ,hr_form_items_b ip1
121: hr_form_tab_pages_b ftp
122: ,hr_form_canvases_b fcn
123: ,hr_form_items_b fim
124: ,hr_item_properties_b itp
125: ,hr_item_properties_tl itptl
126: WHERE
127: -- vp5.form_item_id (+) = fim.validation_parameter_item_id5

Line 155: ,hr_form_items_b fi1

151: ,fi3.full_item_name
152: ,fi4.full_item_name
153: ,fi5.full_item_name
154: FROM hr_item_properties_b ip
155: ,hr_form_items_b fi1
156: ,hr_form_items_b fi2
157: ,hr_form_items_b fi3
158: ,hr_form_items_b fi4
159: ,hr_form_items_b fi5

Line 156: ,hr_form_items_b fi2

152: ,fi4.full_item_name
153: ,fi5.full_item_name
154: FROM hr_item_properties_b ip
155: ,hr_form_items_b fi1
156: ,hr_form_items_b fi2
157: ,hr_form_items_b fi3
158: ,hr_form_items_b fi4
159: ,hr_form_items_b fi5
160: WHERE ip.form_item_id = p_form_item_id

Line 157: ,hr_form_items_b fi3

153: ,fi5.full_item_name
154: FROM hr_item_properties_b ip
155: ,hr_form_items_b fi1
156: ,hr_form_items_b fi2
157: ,hr_form_items_b fi3
158: ,hr_form_items_b fi4
159: ,hr_form_items_b fi5
160: WHERE ip.form_item_id = p_form_item_id
161: AND fi1.form_item_id (+) = ip.information_parameter_item_id1

Line 158: ,hr_form_items_b fi4

154: FROM hr_item_properties_b ip
155: ,hr_form_items_b fi1
156: ,hr_form_items_b fi2
157: ,hr_form_items_b fi3
158: ,hr_form_items_b fi4
159: ,hr_form_items_b fi5
160: WHERE ip.form_item_id = p_form_item_id
161: AND fi1.form_item_id (+) = ip.information_parameter_item_id1
162: AND fi2.form_item_id (+) = ip.information_parameter_item_id2

Line 159: ,hr_form_items_b fi5

155: ,hr_form_items_b fi1
156: ,hr_form_items_b fi2
157: ,hr_form_items_b fi3
158: ,hr_form_items_b fi4
159: ,hr_form_items_b fi5
160: WHERE ip.form_item_id = p_form_item_id
161: AND fi1.form_item_id (+) = ip.information_parameter_item_id1
162: AND fi2.form_item_id (+) = ip.information_parameter_item_id2
163: AND fi3.form_item_id (+) = ip.information_parameter_item_id3

Line 174: ,hr_form_items_b fi1

170: ,fi3.full_item_name
171: ,fi4.full_item_name
172: ,fi5.full_item_name
173: FROM hr_item_properties_b ip
174: ,hr_form_items_b fi1
175: ,hr_form_items_b fi2
176: ,hr_form_items_b fi3
177: ,hr_form_items_b fi4
178: ,hr_form_items_b fi5

Line 175: ,hr_form_items_b fi2

171: ,fi4.full_item_name
172: ,fi5.full_item_name
173: FROM hr_item_properties_b ip
174: ,hr_form_items_b fi1
175: ,hr_form_items_b fi2
176: ,hr_form_items_b fi3
177: ,hr_form_items_b fi4
178: ,hr_form_items_b fi5
179: WHERE ip.form_item_id = p_form_item_id

Line 176: ,hr_form_items_b fi3

172: ,fi5.full_item_name
173: FROM hr_item_properties_b ip
174: ,hr_form_items_b fi1
175: ,hr_form_items_b fi2
176: ,hr_form_items_b fi3
177: ,hr_form_items_b fi4
178: ,hr_form_items_b fi5
179: WHERE ip.form_item_id = p_form_item_id
180: AND fi1.form_item_id (+) = ip.validation_parameter_item_id1

Line 177: ,hr_form_items_b fi4

173: FROM hr_item_properties_b ip
174: ,hr_form_items_b fi1
175: ,hr_form_items_b fi2
176: ,hr_form_items_b fi3
177: ,hr_form_items_b fi4
178: ,hr_form_items_b fi5
179: WHERE ip.form_item_id = p_form_item_id
180: AND fi1.form_item_id (+) = ip.validation_parameter_item_id1
181: AND fi2.form_item_id (+) = ip.validation_parameter_item_id2

Line 178: ,hr_form_items_b fi5

174: ,hr_form_items_b fi1
175: ,hr_form_items_b fi2
176: ,hr_form_items_b fi3
177: ,hr_form_items_b fi4
178: ,hr_form_items_b fi5
179: WHERE ip.form_item_id = p_form_item_id
180: AND fi1.form_item_id (+) = ip.validation_parameter_item_id1
181: AND fi2.form_item_id (+) = ip.validation_parameter_item_id2
182: AND fi3.form_item_id (+) = ip.validation_parameter_item_id3

Line 263: (p_form_item_id IN hr_form_items_b.form_item_id%TYPE

259: -- -----------------------------------------------------------------------------
260: -- |-----------------------------< full_item_name >----------------------------|
261: -- -----------------------------------------------------------------------------
262: FUNCTION full_item_name
263: (p_form_item_id IN hr_form_items_b.form_item_id%TYPE
264: )
265: RETURN hr_form_items_b.full_item_name%TYPE
266: IS
267: --

Line 265: RETURN hr_form_items_b.full_item_name%TYPE

261: -- -----------------------------------------------------------------------------
262: FUNCTION full_item_name
263: (p_form_item_id IN hr_form_items_b.form_item_id%TYPE
264: )
265: RETURN hr_form_items_b.full_item_name%TYPE
266: IS
267: --
268: CURSOR csr_form_items
269: (p_form_item_id IN hr_form_items_b.form_item_id%TYPE

Line 269: (p_form_item_id IN hr_form_items_b.form_item_id%TYPE

265: RETURN hr_form_items_b.full_item_name%TYPE
266: IS
267: --
268: CURSOR csr_form_items
269: (p_form_item_id IN hr_form_items_b.form_item_id%TYPE
270: )
271: IS
272: SELECT fim.full_item_name
273: FROM hr_form_items_b fim

Line 273: FROM hr_form_items_b fim

269: (p_form_item_id IN hr_form_items_b.form_item_id%TYPE
270: )
271: IS
272: SELECT fim.full_item_name
273: FROM hr_form_items_b fim
274: WHERE fim.form_item_id = p_form_item_id;
275: l_form_item csr_form_items%ROWTYPE;
276: --
277: BEGIN