DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ELCT_CHC_FLX_IMP dependencies on BEN_CMBN_PTIP_OPT_F

Line 432: from ben_bnft_prvdr_pool_f bpp,ben_cmbn_ptip_opt_f cpt, ben_opt_f opt,

428: -- Process Combo PTIP Option Level Flex Credits
429: /* bug 1285336
430: cursor c_bpp6 is
431: select bpp.bnft_prvdr_pool_id, bpp.cmbn_ptip_opt_id
432: from ben_bnft_prvdr_pool_f bpp,ben_cmbn_ptip_opt_f cpt, ben_opt_f opt,
433: ben_oipl_f oipl
434: where oipl.oipl_id = l_oipl_id
435: and opt.opt_id = oipl.opt_id
436: and cpt.ptip_id = l_ptip_id

Line 460: ben_cmbn_ptip_opt_f cpt,

456: cursor c_bpp6 is
457: select bpp.bnft_prvdr_pool_id,
458: bpp.cmbn_ptip_opt_id
459: from ben_bnft_prvdr_pool_f bpp,
460: ben_cmbn_ptip_opt_f cpt,
461: ben_optip_f otp,
462: ben_oipl_f oipl
463: where oipl.oipl_id = l_oipl_id
464: and otp.opt_id = oipl.opt_id