APPS.PQH_GSP_HR_TO_STAGE dependencies on DUAL

Line 965: select pqh_gsp_criteria_set_id_s.nextval into l_crset_id from dual;

961: else
962: hr_utility.set_location('data is not to be validated coming from SFL',11);
963: end if;
964: if l_continue then
965: select pqh_gsp_criteria_set_id_s.nextval into l_crset_id from dual;
966: hr_utility.set_location('crset id value is '||l_crset_id,30);
967: create_crset_row
968: (p_crset_id => l_crset_id,
969: p_effective_date => p_effective_date,

Line 1130: select pqh_gsp_criteria_set_id_s.nextval into l_crset_id from dual;

1126: if l_ins_flag then
1127: -- the elp current row is to be inserted in crset table
1128: -- if crset id is null then new crset is to be pulled from seq.
1129: if l_crset_id is null then
1130: select pqh_gsp_criteria_set_id_s.nextval into l_crset_id from dual;
1131: hr_utility.set_location('crset id value is '||l_crset_id,30);
1132: end if;
1133:
1134: l_bu_cd := null;