[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
2554: pos.time_normal_finish,
2555: fnd_number.canonical_to_number(pos.working_hours),
2556: pos.frequency,
2557: pos.location_id
2558: from hr_positions_f pos
2559: where position_id = l_position_id
2560: and l_effective_date
2561: between effective_start_date
2562: and effective_end_date;
2566: pos.time_normal_finish,
2567: fnd_number.canonical_to_number(pos.working_hours),
2568: pos.frequency,
2569: pos.location_id
2570: from hr_positions_f pos
2571: where position_id = l_new_position_id
2572: and l_effective_date
2573: between effective_start_date
2574: and effective_end_date;
2640: mmpos.segment28,
2641: mmpos.segment29,
2642: mmpos.segment30
2643: from per_mm_positions mmpos,
2644: hr_positions_f pos
2645: where mmpos.mass_move_id = p_mass_move_id
2646: and mmpos.position_id = pos.position_id
2647: and mmpos.select_position = 'Y'
2648: and l_effective_date BETWEEN pos.effective_start_date