DBA Data[Home] [Help]

APPS.PER_VAC_BUS dependencies on HR_ALL_POSITIONS_F

Line 830: from hr_all_positions_f hp

826: l_pos_bus_group_id per_all_vacancies.business_group_id%TYPE;
827: --
828: cursor csr_valid_pos is
829: select hp.business_group_id
830: from hr_all_positions_f hp
831: , per_shared_types ps
832: where hp.position_id = p_position_id
833: and p_effective_date
834: between hp.effective_start_date

Line 1005: from hr_all_positions_f hp

1001: --
1002:
1003: cursor csr_valid_pos_org_comb is
1004: select null
1005: from hr_all_positions_f hp
1006: where hp.position_id = p_position_id
1007: and p_effective_date
1008: between hp.effective_start_date
1009: and hp.effective_end_date

Line 1094: from hr_all_positions_f hp

1090: --
1091: --
1092: cursor csr_valid_pos_job_comb is
1093: select null
1094: from hr_all_positions_f hp
1095: where hp.position_id = p_position_id
1096: and p_effective_date
1097: between hp.effective_start_date
1098: and hp.effective_end_date