[Home] [Help]
927: ,proposed_date_for_layoff
928: ,pay_basis_id
929: ,supervisor_id
930: --,copied_to_old_table_flag
931: from hr_positions_f
932: where position_id = p_position_id
933: and p_date_effective
934: between effective_start_date
935: and effective_end_date;
940: ,object_version_number
941: ,date_effective
942: ,date_end
943: ,organization_id
944: from hr_positions_f
945: where position_definition_id = l_position_definition_id
946: and business_group_id = l_business_group_id
947: and p_date_effective
948: between effective_start_date
1080: -- Add as part of fix for bug 2943725
1081: --
1082: cursor csr_current_status is
1083: select pst.system_type_cd
1084: from hr_positions_f hpf,
1085: per_shared_types pst
1086: where lookup_type = 'POSITION_AVAILABILITY_STATUS'
1087: and pst.shared_type_id = hpf.availability_status_id
1088: and hpf.position_id = p_position_id
2552: pos.time_normal_finish,
2553: fnd_number.canonical_to_number(pos.working_hours),
2554: pos.frequency,
2555: pos.location_id
2556: from hr_positions_f pos
2557: where position_id = l_position_id
2558: and l_effective_date
2559: between effective_start_date
2560: and effective_end_date;
2564: pos.time_normal_finish,
2565: fnd_number.canonical_to_number(pos.working_hours),
2566: pos.frequency,
2567: pos.location_id
2568: from hr_positions_f pos
2569: where position_id = l_new_position_id
2570: and l_effective_date
2571: between effective_start_date
2572: and effective_end_date;
2638: mmpos.segment28,
2639: mmpos.segment29,
2640: mmpos.segment30
2641: from per_mm_positions mmpos,
2642: hr_positions_f pos
2643: where mmpos.mass_move_id = p_mass_move_id
2644: and mmpos.position_id = pos.position_id
2645: and mmpos.select_position = 'Y'
2646: and l_effective_date BETWEEN pos.effective_start_date