DBA Data[Home] [Help]

APPS.PER_QH_POPULATE dependencies on HR_POSITIONS_F

Line 705: from hr_positions_f

701: --
702: cursor chk_pos_org(ln_position_id number
703: ,ln_organization_id number) is
704: select 1
705: from hr_positions_f
706: where organization_id=ln_organization_id
707: and position_id=ln_position_id
708: and p_effective_date between effective_start_date
709: and effective_end_date;

Line 921: from hr_positions_f

917: --
918: cursor chk_job_pos(ln_job_id number
919: ,ln_position_id number) is
920: select 1
921: from hr_positions_f
922: where job_id=ln_job_id
923: and position_id=ln_position_id
924: and p_effective_date between effective_start_date
925: and effective_end_date;

Line 930: from hr_positions_f

926: --
927: cursor chk_pos_org(ln_position_id number
928: ,ln_organization_id number) is
929: select 1
930: from hr_positions_f
931: where organization_id=ln_organization_id
932: and position_id=ln_position_id
933: and p_effective_date between effective_start_date
934: and effective_end_date;