APPS.PQH_RBC_STAGE_TO_RBC dependencies on BEN_COPY_ENTITY_RESULTS

Line 21: from ben_copy_entity_results

17: hr_utility.set_location('Into get_parent_rmn copy_entity_result_id'||p_copy_entity_result_id,210);
18:
19: select information1
20: into l_parent_id
21: from ben_copy_entity_results
22: where copy_entity_txn_id = p_copy_entity_txn_id
23: and copy_entity_result_id = p_copy_entity_result_id
24: and table_alias = 'RMN';
25:

Line 91: hr_utility.set_location('writing back on ben_copy_entity results ',210);

87:
88: Begin
89: hr_utility.set_location('inside rmn_writeback ',210);
90:
91: hr_utility.set_location('writing back on ben_copy_entity results ',210);
92: hr_utility.set_location('writing back parent_id '||p_rmn_id,210);
93:
94: update ben_copy_entity_results
95: set information1 = p_rmn_id

Line 94: update ben_copy_entity_results

90:
91: hr_utility.set_location('writing back on ben_copy_entity results ',210);
92: hr_utility.set_location('writing back parent_id '||p_rmn_id,210);
93:
94: update ben_copy_entity_results
95: set information1 = p_rmn_id
96: where COPY_ENTITY_RESULT_ID = p_copy_entity_result_id
97: and copy_entity_txn_id = p_copy_entity_txn_id;
98:

Line 99: update ben_copy_entity_results

95: set information1 = p_rmn_id
96: where COPY_ENTITY_RESULT_ID = p_copy_entity_result_id
97: and copy_entity_txn_id = p_copy_entity_txn_id;
98:
99: update ben_copy_entity_results
100: set information161 = p_rmn_id
101: where GS_PARENT_ENTITY_RESULT_ID = p_copy_entity_result_id
102: and copy_entity_txn_id = p_copy_entity_txn_id
103: and table_alias in ('RMV');

Line 105: update ben_copy_entity_results

101: where GS_PARENT_ENTITY_RESULT_ID = p_copy_entity_result_id
102: and copy_entity_txn_id = p_copy_entity_txn_id
103: and table_alias in ('RMV');
104:
105: update ben_copy_entity_results
106: set information161 = p_rmn_id
107: where PARENT_ENTITY_RESULT_ID = p_copy_entity_result_id
108: and copy_entity_txn_id = p_copy_entity_txn_id
109: and table_alias in ('RMR');

Line 299: from ben_copy_entity_results

295: p_Date_Track_Mode in Varchar2) is
296:
297: cursor del_rmr is
298: select *
299: from ben_copy_entity_results
300: where copy_entity_txn_id = p_copy_entity_txn_id
301: and table_alias = 'RMR'
302: and dml_operation = 'DELETE';
303:

Line 333: from ben_copy_entity_results

329: p_business_group_id in number) is
330:
331: cursor del_rmv is
332: select *
333: from ben_copy_entity_results
334: where copy_entity_txn_id = p_copy_entity_txn_id
335: and table_alias = 'RMV'
336: and dml_operation = 'DELETE';
337: Begin

Line 364: from ben_copy_entity_results

360: p_business_group_id in number) is
361:
362: cursor del_rmn is
363: select *
364: from ben_copy_entity_results
365: where copy_entity_txn_id = p_copy_entity_txn_id
366: and table_alias = 'RMN'
367: and dml_operation = 'DELETE';
368:

Line 394: from ben_copy_entity_results

390: p_Date_Track_Mode in varchar2) is
391:
392: cursor del_plan is
393: select *
394: from ben_copy_entity_results
395: where copy_entity_txn_id = p_copy_entity_txn_id
396: and table_alias = 'PLN'
397: and dml_operation = 'DELETE';
398:

Line 508: from ben_copy_entity_results

504: l_criteria_short_code varchar2(80);
505: l_elig_prfl_id number;
506: cursor csr_rmv is
507: select *
508: from ben_copy_entity_results
509: where copy_entity_txn_id = p_copy_entity_txn_id
510: and table_alias = 'RMV'
511: and dml_operation in ('CREATE','UPDATE')
512: and information161 = p_rmn_id;

Line 769: from ben_copy_entity_results

765: l_base_rt_exist varchar2(1);
766:
767: cursor csr_rmr is
768: select *
769: from ben_copy_entity_results
770: where copy_entity_txn_id = p_copy_entity_txn_id
771: and table_alias = 'RMR'
772: and dml_operation in ('CREATE','UPDATE')
773: and information161 = p_rmn_id;

Line 977: Delete from Ben_Copy_Entity_Results

973: where copy_entity_txn_id = p_copy_entity_txn_id;
974:
975: -- Purging the Copy Entity Txn record as it is no longer required --
976:
977: Delete from Ben_Copy_Entity_Results
978: where Copy_Entity_Txn_Id = p_copy_entity_txn_id;
979: -- and table_alias in ('PLN','RMN','RMV','RMR','RBR',');
980:
981:

Line 1053: from ben_copy_entity_results

1049: l_pl_typ_id number;
1050: l_dt_mode varchar2(1000);
1051: cursor csr_plan is
1052: select *
1053: from ben_copy_entity_results
1054: where copy_entity_txn_id = p_copy_entity_txn_id
1055: and table_alias = 'PLN'
1056: and dml_operation in ('CREATE','UPDATE');
1057: begin

Line 1187: from ben_copy_entity_results

1183: l_parent_rmn_id number;
1184: l_elp_id number;
1185: cursor csr_rmn is
1186: select *
1187: from ben_copy_entity_results
1188: where copy_entity_txn_id = p_copy_entity_txn_id
1189: and table_alias = 'RMN'
1190: and dml_operation in ('CREATE','UPDATE')
1191: order by information160;