DBA Data[Home] [Help]

APPS.BEN_PCS_BUS dependencies on BEN_PRTT_ENRT_CTFN_PRVDD_F

Line 310: ben_prtt_enrt_ctfn_prvdd_f ctfn

306: --
307: CURSOR c1 IS
308: select actn.due_dt
309: from ben_prtt_enrt_actn_f actn,
310: ben_prtt_enrt_ctfn_prvdd_f ctfn
311: where ctfn.prtt_enrt_actn_id = actn.prtt_enrt_actn_id
312: and ctfn.prtt_enrt_rslt_id = actn.prtt_enrt_rslt_id
313: and ctfn.prtt_enrt_actn_id = p_prtt_enrt_actn_id
314: and ctfn.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 811: ben_prtt_enrt_ctfn_prvdd_f b

807: --
808: cursor csr_leg_code is
809: select a.legislation_code
810: from per_business_groups a,
811: ben_prtt_enrt_ctfn_prvdd_f b
812: where b.prtt_enrt_ctfn_prvdd_id = p_prtt_enrt_ctfn_prvdd_id
813: and a.business_group_id = b.business_group_id;
814: --
815: -- Declare local variables