APPS.BEN_ELIGIBILITY_RULE_API dependencies on BEN_PRTN_ELIG_F

Line 269: from ben_prtn_elig_f a,

265: update ben_pgm_f c
266: set c.elig_apls_flag = 'Y'
267: where exists
268: (select a.pgm_id
269: from ben_prtn_elig_f a,
270: ben_prtn_eligy_rl_f b
271: where b.prtn_eligy_rl_id = l_prtn_eligy_rl_id
272: and a.prtn_elig_id = b.prtn_elig_id
273: and a.pgm_id = c.pgm_id);

Line 280: from ben_prtn_elig_f a,

276: update ben_plip_f c
277: set c.elig_apls_flag = 'Y'
278: where exists
279: (select a.plip_id
280: from ben_prtn_elig_f a,
281: ben_prtn_eligy_rl_f b
282: where b.prtn_eligy_rl_id = l_prtn_eligy_rl_id
283: and a.prtn_elig_id = b.prtn_elig_id
284: and a.plip_id = c.plip_id);

Line 291: from ben_prtn_elig_f a,

287: update ben_ptip_f c
288: set c.elig_apls_flag = 'Y'
289: where exists
290: (select a.ptip_id
291: from ben_prtn_elig_f a,
292: ben_prtn_eligy_rl_f b
293: where b.prtn_eligy_rl_id = l_prtn_eligy_rl_id
294: and a.prtn_elig_id = b.prtn_elig_id
295: and a.ptip_id = c.ptip_id);

Line 302: from ben_prtn_elig_f a,

298: update ben_pl_f c
299: set c.elig_apls_flag = 'Y'
300: where exists
301: (select a.pl_id
302: from ben_prtn_elig_f a,
303: ben_prtn_eligy_rl_f b
304: where b.prtn_eligy_rl_id = l_prtn_eligy_rl_id
305: and a.prtn_elig_id = b.prtn_elig_id
306: and a.pl_id = c.pl_id);

Line 313: from ben_prtn_elig_f a,

309: update ben_oipl_f c
310: set c.elig_apls_flag = 'Y'
311: where exists
312: (select a.oipl_id
313: from ben_prtn_elig_f a,
314: ben_prtn_eligy_rl_f b
315: where b.prtn_eligy_rl_id = l_prtn_eligy_rl_id
316: and a.prtn_elig_id = b.prtn_elig_id
317: and a.oipl_id = c.oipl_id);

Line 671: from ben_prtn_elig_f a,

667: ptip_id,
668: plip_id,
669: pl_id,
670: oipl_id
671: from ben_prtn_elig_f a,
672: ben_prtn_eligy_rl_f b
673: where a.prtn_elig_id = b.prtn_elig_id
674: and b.prtn_eligy_rl_id = p_prtn_eligy_rl_id;
675: --

Line 762: from ben_prtn_elig_f a,

758: update ben_pgm_f c
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

Line 768: from ben_prtn_elig_f a,

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
768: from ben_prtn_elig_f a,
769: ben_prtn_eligy_rl_f b
770: where a.prtn_elig_id = b.prtn_elig_id
771: and c.pgm_id = a.pgm_id)
772: and c.pgm_id = l_c1.pgm_id;

Line 782: from ben_prtn_elig_f a,

778: update ben_plip_f c
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

Line 788: from ben_prtn_elig_f a,

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
788: from ben_prtn_elig_f a,
789: ben_prtn_eligy_rl_f b
790: where a.prtn_elig_id = b.prtn_elig_id
791: and c.plip_id = a.plip_id)
792: and c.plip_id = l_c1.plip_id;

Line 802: from ben_prtn_elig_f a,

798: update ben_ptip_f c
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

Line 808: from ben_prtn_elig_f a,

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
808: from ben_prtn_elig_f a,
809: ben_prtn_eligy_rl_f b
810: where a.prtn_elig_id = b.prtn_elig_id
811: and c.ptip_id = a.ptip_id)
812: and c.ptip_id = l_c1.ptip_id;

Line 822: from ben_prtn_elig_f a,

818: update ben_pl_f c
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

Line 828: from ben_prtn_elig_f a,

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
828: from ben_prtn_elig_f a,
829: ben_prtn_eligy_rl_f b
830: where a.prtn_elig_id = b.prtn_elig_id
831: and c.pl_id = a.pl_id)
832: and c.pl_id = l_c1.pl_id;

Line 842: from ben_prtn_elig_f a,

838: update ben_oipl_f c
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

Line 848: from ben_prtn_elig_f a,

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
848: from ben_prtn_elig_f a,
849: ben_prtn_eligy_rl_f b
850: where a.prtn_elig_id = b.prtn_elig_id
851: and c.oipl_id = a.oipl_id)
852: and c.oipl_id = l_c1.oipl_id;