DBA Data[Home] [Help]

APPS.PER_QH_POPULATE dependencies on HR_POSITIONS_F

Line 712: from hr_positions_f

708: --
709: cursor chk_pos_org(ln_position_id number
710: ,ln_organization_id number) is
711: select 1
712: from hr_positions_f
713: where organization_id=ln_organization_id
714: and position_id=ln_position_id
715: and p_effective_date between effective_start_date
716: and effective_end_date;

Line 928: from hr_positions_f

924: --
925: cursor chk_job_pos(ln_job_id number
926: ,ln_position_id number) is
927: select 1
928: from hr_positions_f
929: where job_id=ln_job_id
930: and position_id=ln_position_id
931: and p_effective_date between effective_start_date
932: and effective_end_date;

Line 937: from hr_positions_f

933: --
934: cursor chk_pos_org(ln_position_id number
935: ,ln_organization_id number) is
936: select 1
937: from hr_positions_f
938: where organization_id=ln_organization_id
939: and position_id=ln_position_id
940: and p_effective_date between effective_start_date
941: and effective_end_date;