APPS.BEN_EXT_THREAD dependencies on HR_ALL_POSITIONS_F

Line 4592: ' (select 1 from HR_ALL_POSITIONS_F pos where pos.position_id = ben_asg.position_id and '||

4588: ' erd.ext_rslt_id = ' || p_ext_rslt_id ||
4589: ' and group_val_01 is not null and group_val_01 = job.name ) ) ' ;
4590: elsif l_pdl_val1 = 'PDLPOS' then
4591: l_dynamic_sql := l_dynamic_sql ||
4592: ' (select 1 from HR_ALL_POSITIONS_F pos where pos.position_id = ben_asg.position_id and '||
4593: ' to_date(''' || to_char(p_effective_date,'DD-MM-RRRR') ||
4594: ''',''DD-MM-RRRR'') between pos.effective_start_date and pos.effective_end_date and ' ||
4595: ' exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||
4596: ' erd.ext_rslt_id = ' || p_ext_rslt_id ||

Line 4895: from HR_ALL_POSITIONS_F pos

4891:
4892: cursor c_pos(p_org_id number,
4893: p_bg_id number ) is
4894: select pos.position_id,pos.job_id
4895: from HR_ALL_POSITIONS_F pos
4896: where pos.business_group_id = p_bg_id
4897: and pos.organization_id = p_org_id
4898: and p_effective_date between pos.EFFECTIVE_START_DATE
4899: and nvl(pos.EFFECTIVE_END_DATE ,p_effective_date)

Line 4950: HR_ALL_POSITIONS_F pos

4946: ) is
4947: select
4948: distinct pos.position_id position_id
4949: from ghr_pa_history gph ,
4950: HR_ALL_POSITIONS_F pos
4951: where ( (gph.table_name = 'HR_ALL_POSITIONS_F'
4952: and pos.POSITION_ID = gph.information1 )
4953: or (gph.table_name = 'PER_POSITION_EXTRA_INFO'
4954: and pos.position_id = gph.information4 -- info4 is position_id

Line 4951: where ( (gph.table_name = 'HR_ALL_POSITIONS_F'

4947: select
4948: distinct pos.position_id position_id
4949: from ghr_pa_history gph ,
4950: HR_ALL_POSITIONS_F pos
4951: where ( (gph.table_name = 'HR_ALL_POSITIONS_F'
4952: and pos.POSITION_ID = gph.information1 )
4953: or (gph.table_name = 'PER_POSITION_EXTRA_INFO'
4954: and pos.position_id = gph.information4 -- info4 is position_id
4955: and gph.information5 in ('GHR_US_POS_GRP1','GHR_US_POS_GRP2' ,'GHR_US_POS_VALID_GRADE','GHR_US_POS_GRP3',