APPS.PQH_RBC_UTILITY dependencies on BEN_ELIGY_CRITERIA_S

Line 399: -- get new ben_eligy_criteria sequence --NOT NEEDED BCOZ WE USE API TO CREATE

395: l_egl_cer_id number;
396: l_egl_ovn number;
397: l_ben_eligy_criteria number;
398: begin
399: -- get new ben_eligy_criteria sequence --NOT NEEDED BCOZ WE USE API TO CREATE
400:
401: select BEN_ELIGY_CRITERIA_S.NEXTVAL into l_ben_eligy_criteria from dual;
402:
403: pqh_gsp_hr_to_stage.get_table_route_details

Line 401: select BEN_ELIGY_CRITERIA_S.NEXTVAL into l_ben_eligy_criteria from dual;

397: l_ben_eligy_criteria number;
398: begin
399: -- get new ben_eligy_criteria sequence --NOT NEEDED BCOZ WE USE API TO CREATE
400:
401: select BEN_ELIGY_CRITERIA_S.NEXTVAL into l_ben_eligy_criteria from dual;
402:
403: pqh_gsp_hr_to_stage.get_table_route_details
404: (p_table_alias => 'EGL',
405: p_table_route_id => l_egl_tr_id,

Line 691: update ben_eligy_criteria set

687: close csr_fvs;
688:
689: if l_eligy_criteria_id is not null then
690: --
691: update ben_eligy_criteria set
692: name = p_name,
693: description = p_description,
694: crit_col1_val_type_cd = p_crit_col1_val_type_cd,
695: crit_col1_datatype = p_crit_col1_datatype,

Line 721: update ben_eligy_criteria set

717: -- Update any BG specific rows that were created.
718: --
719: For bg_crit_rec in csr_bg_bec loop
720: --
721: update ben_eligy_criteria set
722: name = p_name,
723: description = p_description,
724: crit_col1_val_type_cd = p_crit_col1_val_type_cd,
725: crit_col1_datatype = p_crit_col1_datatype,

Line 783: ben_eligy_criteria_s.nextval,

779: object_version_number
780: )
781: values
782: (
783: ben_eligy_criteria_s.nextval,
784: p_short_code,
785: p_name,
786: p_description,
787: p_crit_col1_val_type_cd,