APPS.PQH_GSP_GRD_STEP_REMOVE dependencies on STANDARD

Line 186: -- Get Standard Rates i.e HRRATE, ABR Attached to OPT

182:
183: PROCEDURE purge_opt_abr_hrrate_crrate ( p_opt_result_id IN NUMBER,
184: p_copy_entity_txn_id IN NUMBER,
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')

Line 232: -- 1) Purge Standard Rates i.e ABR, HRRATE

228: --------------------------- remove_opt -----------------------------
229: --
230: -- To Remove OPT Rec
231: -- if opt.dml_operation = 'INSERT' then
232: -- 1) Purge Standard Rates i.e ABR, HRRATE
233: -- 2) Purge Crit Rates i.e CRRATE
234: -- 3) Purge Pay Scale if the OPT is the last rec
235: -- 4) Purge OPT Rec
236: -- else if opt.dml_operation in ('COPIED','UPD_INS','UPDATE')

Line 452: 1) Purge Standard Rates and Criteria Rates

448: -- To Remove OIPL Rec in POINT Flavour
449: /*
450: if use_prg_points = 'POINT'
451: if oipl.dml_operation = 'INSERT'
452: 1) Purge Standard Rates and Criteria Rates
453: 1.a) Purge Standard Rates i.e ABR, HRRATE
454: 1.b) Purge Criteria Rates i.e CRRATE
455: 2) Purge Elig Profile call procedure Pqh_Gsp_Grd_Step_Remove.remove_elig_profile
456: 3) purge OIPL

Line 453: 1.a) Purge Standard Rates i.e ABR, HRRATE

449: /*
450: if use_prg_points = 'POINT'
451: if oipl.dml_operation = 'INSERT'
452: 1) Purge Standard Rates and Criteria Rates
453: 1.a) Purge Standard Rates i.e ABR, HRRATE
454: 1.b) Purge Criteria Rates i.e CRRATE
455: 2) Purge Elig Profile call procedure Pqh_Gsp_Grd_Step_Remove.remove_elig_profile
456: 3) purge OIPL
457: else if opt.dml_operation in ('COPIED','UPD_INS','UPDATE')

Line 492: -- 1) Purge Standard Rates : ABR, HRRATE and Criteria Rates : CRRATE

488: hr_utility.set_location ('OPT Result Id:' || l_opt_result_id, 46);
489:
490: IF l_point_or_step = 'POINT' THEN
491: IF l_dml_operation = 'INSERT' OR l_dml_operation ='COPIED' OR l_dml_operation = 'UPD_INS' THEN
492: -- 1) Purge Standard Rates : ABR, HRRATE and Criteria Rates : CRRATE
493: /* hr_utility.set_location ( 'Calling purge_opt_abr_hrrate_crrate ... :', 70);
494: pqh_gsp_grd_step_remove.purge_opt_abr_hrrate_crrate (
495: p_opt_result_id => l_opt_result_id,
496: p_copy_entity_txn_id => p_copy_entity_txn_id,

Line 663: -- Get Standard Rates i.e HRRATE, ABR Attached to OPT

659: )
660: IS
661: l_proc VARCHAR2 (72) := g_package || 'purge_opt_abr_hrrate_crrate ';
662:
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