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

Line 15: FROM ben_copy_entity_results

11: l_ovn NUMBER;
12:
13: CURSOR csr_ovn IS
14: SELECT object_version_number
15: FROM ben_copy_entity_results
16: WHERE copy_entity_result_id = p_copy_entity_result_id;
17: BEGIN
18: hr_utility.set_location ('Entering get_ovn', 10);
19: OPEN csr_ovn;

Line 36: FROM ben_copy_entity_results

32: l_dml_operation VARCHAR2 (40);
33:
34: CURSOR csr_dml_operation IS
35: SELECT dml_operation
36: FROM ben_copy_entity_results
37: WHERE copy_entity_result_id = p_copy_entity_result_id;
38: BEGIN
39: hr_utility.set_location ('Entering get_dml_operation', 10);
40: OPEN csr_dml_operation;

Line 65: ben_copy_entity_results_api.delete_copy_entity_results (

61: l_ovn := get_ovn (p_copy_entity_result_id => p_copy_entity_result_id);
62: else
63: l_ovn := p_object_version_number;
64: end if;
65: ben_copy_entity_results_api.delete_copy_entity_results (
66: p_copy_entity_result_id => p_copy_entity_result_id,
67: p_effective_date => p_effective_date,
68: p_object_version_number => l_ovn
69: );

Line 91: ben_copy_entity_results_api.update_copy_entity_results (

87: l_ovn NUMBER;
88: BEGIN
89: hr_utility.set_location ('Entering update_rec', 10);
90: l_ovn := get_ovn (p_copy_entity_result_id => p_copy_entity_result_id);
91: ben_copy_entity_results_api.update_copy_entity_results (
92: p_copy_entity_result_id => p_copy_entity_result_id,
93: p_effective_date => p_effective_date,
94: p_information104 => 'UNLINK',
95: p_object_version_number => l_ovn,

Line 120: FROM ben_copy_entity_results opt

116: l_count NUMBER;
117:
118: CURSOR csr_scale_cer_id IS
119: SELECT opt.copy_entity_txn_id, opt.information256 -- Pay Scale Cer Id
120: FROM ben_copy_entity_results opt
121: WHERE opt.copy_entity_result_id = p_opt_result_id
122: AND opt.table_alias = 'OPT'
123: AND NVL (opt.information104, 'PPP') <> 'UNLINK'
124: AND opt.copy_entity_txn_id = p_copy_entity_txn_id;

Line 129: FROM ben_copy_entity_results opt

125:
126: -- Count the Number of Options attached to Pay Scale
127: CURSOR csr_num_opts (l_scale_cer_id NUMBER) IS
128: SELECT COUNT (opt.copy_entity_result_id)
129: FROM ben_copy_entity_results opt
130: WHERE opt.information256 = l_scale_cer_id
131: AND opt.copy_entity_txn_id = l_cet_id
132: AND opt.table_alias = 'OPT';
133:

Line 138: FROM ben_copy_entity_results

134: --And Nvl(opt.Information104,'PPP') <> 'UNLINK';
135:
136: CURSOR csr_plip_cer_id (p_scale_cer_id IN NUMBER) IS
137: SELECT copy_entity_result_id
138: FROM ben_copy_entity_results
139: WHERE information258 = p_scale_cer_id
140: AND copy_entity_txn_id = l_cet_id;
141: BEGIN
142: hr_utility.set_location ('Entering purge_pay_scale', 10);

Line 158: UPDATE ben_copy_entity_results

154: delete_rec ( p_copy_entity_result_id => l_scale_cer_id,
155: p_effective_date => p_effective_date);
156: FOR rec_plip_cer_id IN csr_plip_cer_id (l_scale_cer_id) LOOP
157: hr_utility.set_location ( 'Plip Cer Id ' || rec_plip_cer_id.copy_entity_result_id, 10);
158: UPDATE ben_copy_entity_results
159: SET information98 = NULL,
160: information255 = NULL,
161: information258 = NULL,
162: information259 = NULL,

Line 189: FROM ben_copy_entity_results stdrate

185: p_effective_date IN DATE) IS
186: -- Get Standard Rates i.e HRRATE, ABR Attached to OPT
187: CURSOR csr_std_rates IS
188: SELECT stdrate.copy_entity_result_id, stdrate.object_version_number
189: FROM ben_copy_entity_results stdrate
190: WHERE stdrate.table_alias IN ('HRRATE', 'ABR')
191: AND stdrate.information278 = p_opt_result_id
192: AND stdrate.copy_entity_txn_id = p_copy_entity_txn_id;
193:

Line 197: FROM ben_copy_entity_results crrate

193:
194: -- Get Criteria Rate GRRATE
195: CURSOR csr_crrate IS
196: SELECT crrate.copy_entity_result_id, crrate.object_version_number
197: FROM ben_copy_entity_results crrate
198: WHERE crrate.copy_entity_txn_id = p_copy_entity_txn_id
199: AND crrate.table_alias = 'CRRATE'
200: AND crrate.information169 = p_opt_result_id;
201: BEGIN

Line 322: FROM ben_copy_entity_results elp

318: l_elp_cer_id NUMBER;
319:
320: CURSOR csr_elp_cer_ids IS
321: SELECT elp.copy_entity_result_id
322: FROM ben_copy_entity_results elp
323: WHERE elp.copy_entity_txn_id = p_copy_entity_txn_id
324: AND elp.gs_parent_entity_result_id = p_copy_entity_result_id
325: AND elp.table_alias = 'ELP';
326: BEGIN

Line 378: FROM ben_copy_entity_results oipl

374: l_opt_result_id NUMBER;
375:
376: CURSOR csr_opt_result_id IS
377: SELECT oipl.information262
378: FROM ben_copy_entity_results oipl
379: WHERE oipl.copy_entity_txn_id = p_copy_entity_txn_id
380: AND oipl.table_alias = 'COP'
381: AND oipl.copy_entity_result_id = p_copy_entity_result_id;
382: BEGIN

Line 473: FROM ben_copy_entity_results oipl

469: l_opt_result_id NUMBER;
470:
471: CURSOR csr_opt_result_id IS
472: SELECT oipl.information262
473: FROM ben_copy_entity_results oipl
474: WHERE oipl.copy_entity_txn_id = p_copy_entity_txn_id
475: AND oipl.table_alias = 'COP'
476: AND oipl.copy_entity_result_id = p_copy_entity_result_id;
477: BEGIN

Line 583: FROM ben_copy_entity_results pln

579: l_pln_cer_id NUMBER;
580:
581: CURSOR csr_plan_result_id IS
582: SELECT pln.copy_entity_result_id
583: FROM ben_copy_entity_results pln
584: WHERE pln.gs_mirror_src_entity_result_id = p_copy_entity_result_id
585: AND pln.copy_entity_txn_id = p_copy_entity_txn_id
586: AND pln.table_alias = 'PLN';
587:

Line 590: FROM ben_copy_entity_results oipl

586: AND pln.table_alias = 'PLN';
587:
588: CURSOR csr_oipl_ids IS
589: SELECT oipl.copy_entity_result_id
590: FROM ben_copy_entity_results oipl
591: WHERE oipl.gs_parent_entity_result_id = p_copy_entity_result_id
592: AND oipl.table_alias = 'COP'
593: AND oipl.copy_entity_txn_id = p_copy_entity_txn_id;
594:

Line 635: update ben_copy_entity_results

631: -- 2) Purge PLIP Rec
632: OPEN csr_plan_result_id;
633: FETCH csr_plan_result_id INTO l_pln_cer_id;
634: IF csr_plan_result_id%FOUND THEN
635: update ben_copy_entity_results
636: set gs_mirror_src_entity_result_id = null
637: where copy_entity_result_id = l_pln_cer_id;
638: END IF;
639: CLOSE csr_plan_result_id;

Line 667: FROM ben_copy_entity_results stdrate

663: -- Get Standard Rates i.e HRRATE, ABR Attached to OPT
664: CURSOR csr_std_rates
665: IS
666: SELECT stdrate.copy_entity_result_id, stdrate.object_version_number
667: FROM ben_copy_entity_results stdrate
668: WHERE stdrate.table_alias IN ('HRRATE', 'ABR')
669: AND stdrate.information278 = p_opt_result_id
670: AND stdrate.copy_entity_txn_id = p_copy_entity_txn_id;
671:

Line 676: FROM ben_copy_entity_results crrate

672: -- Get Criteria Rate GRRATE
673: CURSOR csr_crrate
674: IS
675: SELECT crrate.copy_entity_result_id, crrate.object_version_number
676: FROM ben_copy_entity_results crrate
677: WHERE crrate.copy_entity_txn_id = p_copy_entity_txn_id
678: AND crrate.table_alias = 'CRRATE'
679: AND crrate.information169 = p_opt_result_id;
680: BEGIN