APPS.BEN_EXT_THREAD dependencies on HR_ALL_POSITIONS_F

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

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

Line 4893: from HR_ALL_POSITIONS_F pos

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

Line 4948: HR_ALL_POSITIONS_F pos

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

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

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