APPS.BEN_EXTRACT_SEED dependencies on HR_ALL_POSITIONS_F
Line 791: from HR_ALL_POSITIONS_F job
787: where business_group_id = p_val;
788:
789: cursor c_pos is
790: select name 791: from HR_ALL_POSITIONS_F job 792: where position_id = p_val
793: and trunc(sysdate) between
794: EFFECTIVE_START_DATE
795: and EFFECTIVE_END_DATE ;
Line 1573: from HR_ALL_POSITIONS_F job
1569: ;
1570:
1571: cursor c_pos is
1572: select position_id 1573: from HR_ALL_POSITIONS_F job 1574: where name = p_meaning
1575: and trunc(sysdate) between
1576: EFFECTIVE_START_DATE
1577: and EFFECTIVE_END_DATE