APPS.BEN_CWB_WS_IMPORT_PKG dependencies on HR_ALL_POSITIONS_F_TL

Line 711: from hr_all_positions_f_tl ptl, hr_all_positions_f p

707: and rownum =1;
708:
709: cursor c_position (bg_id In Number) is
710: select p.position_id
711: from hr_all_positions_f_tl ptl, hr_all_positions_f p
712: where ptl.name = P_PROPOSED_POSITION
713: and ptl.language = 'US'
714: and ptl.position_id = p.position_id
715: and p.business_group_id = bg_id