APPS.BEN_ELIGIBILITY_RULE_API dependencies on BEN_PRTN_ELIG_PRFL_F

Line 763: ben_prtn_elig_prfl_f b

759: set c.elig_apls_flag = 'N'
760: where not exists
761: (select a.pgm_id
762: from ben_prtn_elig_f a,
763: ben_prtn_elig_prfl_f b
764: where a.prtn_elig_id = b.prtn_elig_id
765: and c.pgm_id = a.pgm_id)
766: and not exists
767: (select a.pgm_id

Line 783: ben_prtn_elig_prfl_f b

779: set c.elig_apls_flag = 'N'
780: where not exists
781: (select a.plip_id
782: from ben_prtn_elig_f a,
783: ben_prtn_elig_prfl_f b
784: where a.prtn_elig_id = b.prtn_elig_id
785: and c.plip_id = a.plip_id)
786: and not exists
787: (select a.plip_id

Line 803: ben_prtn_elig_prfl_f b

799: set c.elig_apls_flag = 'N'
800: where not exists
801: (select a.ptip_id
802: from ben_prtn_elig_f a,
803: ben_prtn_elig_prfl_f b
804: where a.prtn_elig_id = b.prtn_elig_id
805: and c.ptip_id = a.ptip_id)
806: and not exists
807: (select a.ptip_id

Line 823: ben_prtn_elig_prfl_f b

819: set c.elig_apls_flag = 'N'
820: where not exists
821: (select a.pl_id
822: from ben_prtn_elig_f a,
823: ben_prtn_elig_prfl_f b
824: where a.prtn_elig_id = b.prtn_elig_id
825: and c.pl_id = a.pl_id)
826: and not exists
827: (select a.pl_id

Line 843: ben_prtn_elig_prfl_f b

839: set c.elig_apls_flag = 'N'
840: where not exists
841: (select a.oipl_id
842: from ben_prtn_elig_f a,
843: ben_prtn_elig_prfl_f b
844: where a.prtn_elig_id = b.prtn_elig_id
845: and c.oipl_id = a.oipl_id)
846: and not exists
847: (select a.oipl_id