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_COPY_ENTITY_RESULTS

Line 7: cursor c1 is select copy_entity_result_id from ben_copy_entity_results

3:
4: function matrix_has_criteria(p_copy_entity_txn_id in number) return varchar2 is
5: l_copy_entity_result_id number;
6:
7: cursor c1 is select copy_entity_result_id from ben_copy_entity_results
8: where copy_entity_txn_id = p_copy_entity_txn_id
9: and table_alias = 'RBC_CRIT' and dml_operation <> 'DELETE';
10: BEGIN
11: open c1;

Line 25: cursor c1 is select copy_entity_result_id from ben_copy_entity_results

21:
22: function matrix_has_rates(p_copy_entity_txn_id in number) return varchar2 is
23: l_copy_entity_result_id number;
24:
25: cursor c1 is select copy_entity_result_id from ben_copy_entity_results
26: where copy_entity_txn_id = p_copy_entity_txn_id
27: and table_alias = 'RMR' and dml_operation <> 'DELETE'
28: and Information297 is not null
29: and Information297 <> 0;

Line 44: cursor c1 is select copy_entity_result_id from ben_copy_entity_results

40:
41: function matrix_has_criteria_values(p_copy_entity_txn_id in number) return varchar2 is
42: l_copy_entity_result_id number;
43:
44: cursor c1 is select copy_entity_result_id from ben_copy_entity_results
45: where copy_entity_txn_id = p_copy_entity_txn_id
46: and table_alias = 'RMV' and dml_operation <> 'DELETE';
47: BEGIN
48: open c1;

Line 66: cursor c1 is select INFORMATION13,INFORMATION160 from ben_copy_entity_results

62: l_name varchar(240);
63: l_level_number number;
64: l_copy_entity_result_id number;
65:
66: cursor c1 is select INFORMATION13,INFORMATION160 from ben_copy_entity_results
67: where copy_entity_txn_id = p_copy_entity_txn_id
68: and table_alias = 'RBC_CRIT' and dml_operation <> 'DELETE';
69:
70: cursor c2(l_sh_code varchar,l_level_num number)

Line 71: is select copy_entity_result_id from ben_copy_entity_results

67: where copy_entity_txn_id = p_copy_entity_txn_id
68: and table_alias = 'RBC_CRIT' and dml_operation <> 'DELETE';
69:
70: cursor c2(l_sh_code varchar,l_level_num number)
71: is select copy_entity_result_id from ben_copy_entity_results
72: where copy_entity_txn_id = p_copy_entity_txn_id
73: and table_alias = 'RMN' and dml_operation <> 'DELETE'
74: and INFORMATION13 = l_sh_code and INFORMATION160 = l_level_num;
75:

Line 117: cursor c1 is Select information1 from ben_copy_entity_results

113:
114: function matrix_has_rate_type(p_copy_entity_txn_id in number) return varchar2 is
115: l_crit_rate_defn_id number;
116:
117: cursor c1 is Select information1 from ben_copy_entity_results
118: Where copy_entity_txn_id = p_copy_entity_txn_id and table_alias = 'RCR';
119:
120: BEGIN
121: open c1;

Line 134: cursor c1 is select count(information13) from ben_copy_entity_results

130:
131: function matrix_has_criteria_dup(p_copy_entity_txn_id in number) return varchar2 is
132: l_crit_rate_defn_id number;
133: l_return_val varchar2(3);
134: cursor c1 is select count(information13) from ben_copy_entity_results
135: where table_alias = 'RBC_CRIT' and dml_operation <> 'DELETE' and copy_entity_txn_id = p_copy_entity_txn_id
136: group by information13;
137:
138: BEGIN

Line 230: from ben_copy_entity_results

226: l_pl_id number;
227: l_business_group_id number;
228: l_status varchar2(10);
229: cursor c1 is select information1,information170, information93, information94, information4
230: from ben_copy_entity_results
231: where copy_entity_txn_id = p_copy_entity_txn_id
232: and table_alias = 'PLN';
233: begin
234: l_status := 'NO';

Line 265: from ben_copy_entity_results

261: l_copy_entity_result_id number;
262: l_status varchar(10);
263: --get all children of node except the current input val row we have to compare
264: cursor c1 is select copy_entity_result_id
265: from ben_copy_entity_results
266: where gs_parent_entity_result_id = p_copy_entity_result_id_node
267: and table_alias = 'RMV' and dml_operation <> 'DELETE'
268: and copy_entity_result_id <> p_copy_entity_result_id_val;
269:

Line 303: from ben_copy_entity_results

299: l_copy_entity_result_id3 number;
300:
301: --get all values in the transaction
302: cursor c1 is select copy_entity_result_id,gs_parent_entity_result_id
303: from ben_copy_entity_results
304: where copy_entity_txn_id = p_copy_entity_txn_id
305: and table_alias = 'RMV' and dml_operation <> 'DELETE';
306:
307: --get parent node id of rmn itself

Line 309: from ben_copy_entity_results

305: and table_alias = 'RMV' and dml_operation <> 'DELETE';
306:
307: --get parent node id of rmn itself
308: cursor c2(node_id number) is select gs_parent_entity_result_id
309: from ben_copy_entity_results
310: where copy_entity_result_id = node_id
311: and table_alias = 'RMN' and dml_operation <> 'DELETE';
312:
313: --get all children nodes of a parent node

Line 315: from ben_copy_entity_results

311: and table_alias = 'RMN' and dml_operation <> 'DELETE';
312:
313: --get all children nodes of a parent node
314: cursor c3(parent_node_id number,exclude_node_id number) is select copy_entity_result_id
315: from ben_copy_entity_results
316: where gs_parent_entity_result_id = parent_node_id
317: and table_alias = 'RMN' and dml_operation <> 'DELETE'
318: and copy_entity_result_id <> exclude_node_id;
319:

Line 413: from ben_copy_entity_results

409: information13,information14,information15,information16,
410: information169,information174,information221,information222,
411: information166,information167,information306,information307,
412: information223,information224,information225,information226
413: from ben_copy_entity_results
414: where copy_entity_result_id = p_copy_entity_result_id
415: and table_alias = 'RMV' and dml_operation <> 'DELETE';
416:
417: begin

Line 495: cursor c1 is Select count(information1) from ben_copy_entity_results

491: function matrix_has_ratetype_dup(p_copy_entity_txn_id in number) return varchar2 is
492: l_crit_rate_defn_id number;
493: l_return_val varchar2(3);
494:
495: cursor c1 is Select count(information1) from ben_copy_entity_results
496: Where copy_entity_txn_id = p_copy_entity_txn_id and table_alias = 'RCR'
497: group by information1;
498:
499: BEGIN

Line 687: from ben_copy_entity_results

683: l_crit_rate_defn_name varchar2(240);
684: l_crit_rate_defn_names varchar2(2400);
685: l_num number;
686: cursor c1 is select Information1
687: from ben_copy_entity_results
688: where
689: table_alias = 'RCR' and dml_operation <> 'DELETE'
690: and copy_entity_txn_id = p_copy_entity_txn_id;
691:

Line 707: select count(*) into l_count from ben_copy_entity_results

703: exit when c1%notfound;
704:
705: select name into l_crit_rate_defn_name from pqh_criteria_rate_defn_vl where criteria_rate_defn_id = l_criteria_rate_defn;
706: l_count := 0;
707: select count(*) into l_count from ben_copy_entity_results
708: where
709: table_alias = 'RMR' and dml_operation <> 'DELETE'
710: and copy_entity_txn_id = p_copy_entity_txn_id
711: and Information162 = l_criteria_rate_defn;