138: l_ptx_deployment_factor_id number;
139: --
140: cursor c_pqh_ptx_dpf_df_s is
141: select pqh_ptx_dpf_df_s.nextval
142: from dual;
143: --
144: CURSOR c1 IS
145: SELECT *
146: FROM hr_positions
768: FOR v_poei_rec in c1 loop
769: -- select the sequence number for pqh_ptx_extra_info
770: select pqh_ptx_extra_info_s.nextval
771: into l_ptx_extra_info_id
772: from dual;
773:
774: -- insert record into pqh_ptx_extra_info
775:
776: insert into pqh_ptx_extra_info
944: FOR r_jre in c1 loop
945: -- select the sequence number for pqh_txn_job_requirements
946: select pqh_txn_job_requirements_s.nextval
947: into l_txn_job_requirement_id
948: from dual;
949:
950: -- insert record into pqh_txn_job_requirements
951:
952: insert into pqh_txn_job_requirements
3345: declare
3346: l_job_requirement_id number;
3347: begin
3348: select per_job_requirements_s.nextval into l_job_requirement_id
3349: from dual;
3350: --
3351: insert into per_job_requirements
3352: (
3353: job_requirement_id, business_group_id, analysis_criteria_id,
3612: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
3613: --
3614: cursor csr_valid_eff_date(p_position_id number, p_validation_start_date date, p_validation_end_date date) is
3615: select p_validation_start_date start_date
3616: from dual
3617: union
3618: select start_date
3619: from (select fnd_date.canonical_to_date(poei_information3) start_date
3620: from per_position_extra_info