DBA Data[Home] [Help]

APPS.BEN_WPT_BUS dependencies on BEN_WV_PRTN_RSN_PTIP_F

Line 255: from ben_wv_prtn_rsn_ptip_f

251: is
252: l_proc varchar2(72) := g_package||'chk_only_default_one';
253: l_dummy char(1);
254: cursor c1 is select null
255: from ben_wv_prtn_rsn_ptip_f
256: Where ptip_id = p_ptip_id
257: and dflt_flag = 'Y'
258: and wv_prtn_rsn_ptip_id <> nvl(p_wv_prtn_rsn_ptip_id,-1)
259: and p_effective_date between effective_start_date and effective_end_date

Line 631: ben_wv_prtn_rsn_ptip_f b

627: --
628: cursor csr_leg_code is
629: select a.legislation_code
630: from per_business_groups a,
631: ben_wv_prtn_rsn_ptip_f b
632: where b.wv_prtn_rsn_ptip_id = p_wv_prtn_rsn_ptip_id
633: and a.business_group_id = b.business_group_id;
634: --
635: -- Declare local variables