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_GSP_DEL_GRADE_LADDER_OBJ dependencies on BEN_COPY_ENTITY_RESULTS

Line 23: From ben_copy_entity_results

19: information3 effective_end_date,
20: information4 business_group_id,
21: information261 pl_id,
22: information265 ovn
23: From ben_copy_entity_results
24: Where copy_entity_txn_id = p_copy_entity_txn_id
25: And table_alias = 'CPP'
26: And dml_operation = 'DELETE';
27: -- And information104 = 'UNLINK';

Line 131: From ben_copy_entity_results

127: information3 effective_end_date,
128: information4 business_group_id,
129: information247 opt_id,
130: information265 oipl_ovn
131: From ben_copy_entity_results
132: Where copy_entity_txn_id = p_copy_entity_txn_id
133: And table_alias = 'COP'
134: And dml_operation = 'DELETE';
135: -- And information104 = 'UNLINK';

Line 219: From Ben_Copy_Entity_Results Cep,

215:
216: Cursor Csr_Tabl_Alias is
217: Select Obj.Table_Alias , Obj.Dml_Operation,
218: Obj.Gs_Parent_Entity_Result_Id
219: From Ben_Copy_Entity_Results Cep,
220: Ben_Copy_Entity_Results Epa,
221: Ben_Copy_Entity_Results Obj
222: Where Cep.Copy_Entity_Result_id = P_Cer_id
223: and Epa.Copy_Entity_Result_id = Cep.GS_MIRROR_SRC_ENTITY_RESULT_ID

Line 220: Ben_Copy_Entity_Results Epa,

216: Cursor Csr_Tabl_Alias is
217: Select Obj.Table_Alias , Obj.Dml_Operation,
218: Obj.Gs_Parent_Entity_Result_Id
219: From Ben_Copy_Entity_Results Cep,
220: Ben_Copy_Entity_Results Epa,
221: Ben_Copy_Entity_Results Obj
222: Where Cep.Copy_Entity_Result_id = P_Cer_id
223: and Epa.Copy_Entity_Result_id = Cep.GS_MIRROR_SRC_ENTITY_RESULT_ID
224: and Obj.Copy_Entity_Result_id = Epa.GS_MIRROR_SRC_ENTITY_RESULT_ID;

Line 221: Ben_Copy_Entity_Results Obj

217: Select Obj.Table_Alias , Obj.Dml_Operation,
218: Obj.Gs_Parent_Entity_Result_Id
219: From Ben_Copy_Entity_Results Cep,
220: Ben_Copy_Entity_Results Epa,
221: Ben_Copy_Entity_Results Obj
222: Where Cep.Copy_Entity_Result_id = P_Cer_id
223: and Epa.Copy_Entity_Result_id = Cep.GS_MIRROR_SRC_ENTITY_RESULT_ID
224: and Obj.Copy_Entity_Result_id = Epa.GS_MIRROR_SRC_ENTITY_RESULT_ID;
225:

Line 229: from Ben_Copy_Entity_Results Cpp

225:
226: Cursor Csr_plip (P_Cpp_Cer_Id In Number)Is
227: Select Information253 Grade_Id,
228: Information255 Scale_Id
229: from Ben_Copy_Entity_Results Cpp
230: Where Copy_Entity_Txn_id = P_Copy_Entity_Txn_Id
231: and Copy_Entity_Result_Id = p_Cpp_Cer_Id
232: and Table_Alias = 'CPP'
233: and Result_type_Cd = 'DISPLAY';

Line 243: l_table_Alias Ben_Copy_Entity_Results.table_Alias%TYPE;

239: and P_Effective_Date
240: Between Effective_Start_Date
241: and Effective_End_Date;
242:
243: l_table_Alias Ben_Copy_Entity_Results.table_Alias%TYPE;
244: l_Dml_operation Ben_Copy_Entity_Results.Dml_operation%TYPE;
245: l_Plip_Cer_Id Ben_Copy_Entity_Results.Copy_Entity_Result_id%TYPE;
246: l_Grade_Id Per_Grades.Grade_Id%TYPE;
247: l_Scale_Id Per_Parent_SPines.PARENT_SPINE_ID%TYPE;

Line 244: l_Dml_operation Ben_Copy_Entity_Results.Dml_operation%TYPE;

240: Between Effective_Start_Date
241: and Effective_End_Date;
242:
243: l_table_Alias Ben_Copy_Entity_Results.table_Alias%TYPE;
244: l_Dml_operation Ben_Copy_Entity_Results.Dml_operation%TYPE;
245: l_Plip_Cer_Id Ben_Copy_Entity_Results.Copy_Entity_Result_id%TYPE;
246: l_Grade_Id Per_Grades.Grade_Id%TYPE;
247: l_Scale_Id Per_Parent_SPines.PARENT_SPINE_ID%TYPE;
248: l_Parent_Spine_Id Per_Parent_SPines.PARENT_SPINE_ID%TYPE;

Line 245: l_Plip_Cer_Id Ben_Copy_Entity_Results.Copy_Entity_Result_id%TYPE;

241: and Effective_End_Date;
242:
243: l_table_Alias Ben_Copy_Entity_Results.table_Alias%TYPE;
244: l_Dml_operation Ben_Copy_Entity_Results.Dml_operation%TYPE;
245: l_Plip_Cer_Id Ben_Copy_Entity_Results.Copy_Entity_Result_id%TYPE;
246: l_Grade_Id Per_Grades.Grade_Id%TYPE;
247: l_Scale_Id Per_Parent_SPines.PARENT_SPINE_ID%TYPE;
248: l_Parent_Spine_Id Per_Parent_SPines.PARENT_SPINE_ID%TYPE;
249: Begin

Line 296: From ben_copy_entity_results

292: information3 effective_end_date,
293: information4 business_group_id,
294: information265 cep_ovn,
295: Copy_Entity_Result_Id
296: From ben_copy_entity_results
297: Where copy_entity_txn_id = p_copy_entity_txn_id
298: And table_alias = 'CEP'
299: And dml_operation ='DELETE';
300: -- And information104 = 'UNLINK';

Line 318: From ben_copy_entity_results

314: information3 effective_end_date,
315: information4 business_group_id,
316: information265 epa_ovn,
317: Copy_Entity_Result_id
318: From ben_copy_entity_results
319: Where copy_entity_txn_id = p_copy_entity_txn_id
320: And table_alias = 'EPA'
321: And dml_operation ='DELETE';
322: -- And information104 = 'UNLINK';

Line 335: From Ben_Copy_Entity_Results

331: between Effective_Start_Date and Effective_End_Date;
332:
333: Cursor Csr_Epa_cer (P_Epa_Cer_Id IN Number) is
334: Select Copy_Entity_Result_Id
335: From Ben_Copy_Entity_Results
336: Where Copy_Entity_Txn_Id = P_Copy_Entity_Txn_Id
337: and GS_MIRROR_SRC_ENTITY_RESULT_ID = P_Epa_Cer_id;
338: --
339: l_cep_start_date Ben_prtn_elig_prfl_f.effective_start_date%type;

Line 352: l_Cep_Cer Ben_Copy_Entity_Results.Copy_Entity_Result_id%TYPE;

348: --
349: l_eot date;
350: l_datetrack_mode varchar2(30);
351: l_Effective_Date Date;
352: l_Cep_Cer Ben_Copy_Entity_Results.Copy_Entity_Result_id%TYPE;
353: --
354: Begin
355: --
356: l_eot := to_date('31/12/4712','dd/mm/yyyy');

Line 487: From ben_copy_entity_results

483: information2 effective_start_date,
484: information3 effective_end_date,
485: information4 business_group_id,
486: information265 opt_ovn
487: From ben_copy_entity_results
488: Where copy_entity_txn_id = p_copy_entity_txn_id
489: And table_alias = 'OPT'
490: And dml_operation ='DELETE';
491: -- And information104 = 'UNLINK';