DBA Data[Home] [Help]

APPS.HR_PDT_BUS dependencies on HR_POSITIONS_F

Line 2274: from hr_positions_f hp,

2270: l_dummy number;
2271: --
2272: cursor csr_check_position is
2273: select 1
2274: from hr_positions_f hp,
2275: per_shared_types ps
2276: where hp.position_id = p_position_id
2277: and hp.business_group_id = p_to_business_group_id
2278: and p_start_date between

Line 2492: from hr_positions_f hp,

2488: l_dummy number;
2489: --
2490: cursor csr_check_pos_job is
2491: select null
2492: from hr_positions_f hp,
2493: per_shared_types ps
2494: where hp.position_id = p_position_id
2495: and p_start_date between
2496: hp.effective_start_date and hp.effective_end_date

Line 2831: from hr_positions_f hp,

2827: l_dummy number;
2828: --
2829: cursor csr_check_pos_org is
2830: select null
2831: from hr_positions_f hp,
2832: per_shared_types ps
2833: where hp.position_id = p_position_id
2834: and p_start_date between
2835: hp.effective_start_date and hp.effective_end_date