DBA Data[Home] [Help]

APPS.PAY_INTERPRETER_PKG dependencies on BEN_EXT_DFN

Line 4993: ben_ext_dfn bed

4989: pay_event_updates peu
4990: where pde.event_group_id in (select becv.val_1
4991: from ben_ext_crit_val becv,
4992: ben_ext_crit_typ bect,
4993: ben_ext_dfn bed
4994: where becv.ext_crit_typ_id = bect.ext_crit_typ_id
4995: and bect.ext_crit_prfl_id = bed.ext_crit_prfl_id
4996: and bed.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
4997: and bect.crit_typ_cd = 'CPE')

Line 5610: FROM BEN_EXT_DFN

5606: --SELECT 'x'
5607: SELECT nvl(decode(name,'PQP GB PenServer Periodic Changes Interface - Allowance History','A',
5608: 'PQP GB PenServer Periodic Changes Interface - Bonus History','B',
5609: 'N'),'N')
5610: FROM BEN_EXT_DFN
5611: WHERE ext_dfn_id = c_ext_dfn_id
5612: AND name in ('PQP GB PenServer Periodic Changes Interface - Allowance History',
5613: 'PQP GB PenServer Periodic Changes Interface - Bonus History')
5614: AND legislation_code ='GB';