DBA Data[Home] [Help]

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