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.PQH_RBC_VALIDATE dependencies on BEN_PL_F

Line 154: cursor c1 is select name from ben_pl_f

150: END matrix_has_criteria_dup;
151:
152: function plan_name_exists(l_pl_id in number,p_name in varchar2, p_business_group_id in number) return varchar2 is
153: l_name varchar2(240);
154: cursor c1 is select name from ben_pl_f
155: where name = p_name
156: and pl_id <> l_pl_id
157: and business_group_id = p_business_group_id;
158:

Line 178: cursor c1 is select short_code from ben_pl_f

174: --
175:
176: function plan_short_code_exists(l_pl_id in number,p_short_code in varchar2, p_business_group_id in number) return varchar2 is
177: l_short_code varchar2(240);
178: cursor c1 is select short_code from ben_pl_f
179: where short_code = p_short_code
180: and pl_id <> l_pl_id
181: and business_group_id = p_business_group_id;
182:

Line 200: cursor c1 is select short_name from ben_pl_f

196: END plan_short_code_exists;
197: --
198: function plan_short_name_exists(l_pl_id in number,p_short_name in varchar2, p_business_group_id in number) return varchar2 is
199: l_short_name varchar2(240);
200: cursor c1 is select short_name from ben_pl_f
201: where short_name = p_short_name
202: and pl_id <> l_pl_id
203: and business_group_id = p_business_group_id;
204: