APPS.BEN_PRTN_ELIG_PRFL_API dependencies on BEN_PRTN_ELIGY_RL_F

Line 951: ben_prtn_eligy_rl_f b

947: and a.pgm_id = c.pgm_id)
948: and not exists
949: (select a.pgm_id
950: from ben_prtn_elig_f a,
951: ben_prtn_eligy_rl_f b
952: where a.prtn_elig_id = b.prtn_elig_id
953: and a.pgm_id = c.pgm_id)
954: and c.pgm_id = l_c1.pgm_id;
955: -- updates drvbl_fctr_prtn_elig_flag

Line 973: ben_prtn_eligy_rl_f b

969: and a.plip_id = c.plip_id)
970: and not exists
971: (select a.plip_id
972: from ben_prtn_elig_f a,
973: ben_prtn_eligy_rl_f b
974: where a.prtn_elig_id = b.prtn_elig_id
975: and a.plip_id = c.plip_id)
976: and c.plip_id = l_c1.plip_id;
977: --

Line 996: ben_prtn_eligy_rl_f b

992: and a.ptip_id = c.ptip_id)
993: and not exists
994: (select a.ptip_id
995: from ben_prtn_elig_f a,
996: ben_prtn_eligy_rl_f b
997: where a.prtn_elig_id = b.prtn_elig_id
998: and a.ptip_id = c.ptip_id)
999: and c.ptip_id = l_c1.ptip_id;
1000: --

Line 1018: ben_prtn_eligy_rl_f b

1014: and a.pl_id = c.pl_id)
1015: and not exists
1016: (select a.pl_id
1017: from ben_prtn_elig_f a,
1018: ben_prtn_eligy_rl_f b
1019: where a.prtn_elig_id = b.prtn_elig_id
1020: and a.pl_id = c.pl_id)
1021: and c.pl_id = l_c1.pl_id;
1022: --

Line 1041: ben_prtn_eligy_rl_f b

1037: and a.oipl_id = c.oipl_id)
1038: and not exists
1039: (select a.oipl_id
1040: from ben_prtn_elig_f a,
1041: ben_prtn_eligy_rl_f b
1042: where a.prtn_elig_id = b.prtn_elig_id
1043: and a.oipl_id = c.oipl_id)
1044: and c.oipl_id = l_c1.oipl_id;
1045: --