DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on HR_ALL_POSITIONS_F

Line 738: from HR_ALL_POSITIONS_F job

734: where business_group_id = p_val;
735:
736: cursor c_pos is
737: select name
738: from HR_ALL_POSITIONS_F job
739: where position_id = p_val
740: and trunc(sysdate) between
741: EFFECTIVE_START_DATE
742: and EFFECTIVE_END_DATE ;

Line 1520: from HR_ALL_POSITIONS_F job

1516: ;
1517:
1518: cursor c_pos is
1519: select position_id
1520: from HR_ALL_POSITIONS_F job
1521: where name = p_meaning
1522: and trunc(sysdate) between
1523: EFFECTIVE_START_DATE
1524: and EFFECTIVE_END_DATE