APPS.BEN_PRTN_ELIG_PRFL_API dependencies on BEN_PRTN_ELIG_F

Line 66: from ben_prtn_elig_f

62: --
63: -- Declare cursors and local variables
64: --
65: cursor c1(l_prtn_elig_id number) is select pgm_id,pl_id,ptip_id,plip_id,oipl_id
66: from ben_prtn_elig_f
67: where prtn_elig_id = l_prtn_elig_id;
68: l_pgm_id number;
69: l_pl_id number;
70: l_plip_id number;

Line 456: from ben_prtn_elig_f a,

452: ptip_id,
453: plip_id,
454: pl_id,
455: oipl_id
456: from ben_prtn_elig_f a,
457: ben_prtn_elig_prfl_f b
458: where a.prtn_elig_id = b.prtn_elig_id
459: and b.prtn_elig_prfl_id = p_prtn_elig_prfl_id;
460: l_c1 c1%rowtype;

Line 854: from ben_prtn_elig_f a,

850: ptip_id,
851: plip_id,
852: pl_id,
853: oipl_id
854: from ben_prtn_elig_f a,
855: ben_prtn_elig_prfl_f b
856: where a.prtn_elig_id = b.prtn_elig_id
857: and b.prtn_elig_prfl_id = p_prtn_elig_prfl_id;
858: --

Line 944: from ben_prtn_elig_f a,

940: update ben_pgm_f c
941: set c.elig_apls_flag = 'N'
942: where not exists
943: (select a.pgm_id
944: from ben_prtn_elig_f a,
945: ben_prtn_elig_prfl_f b
946: where a.prtn_elig_id = b.prtn_elig_id
947: and a.pgm_id = c.pgm_id)
948: and not exists

Line 950: from ben_prtn_elig_f a,

946: where a.prtn_elig_id = b.prtn_elig_id
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;

Line 966: from ben_prtn_elig_f a,

962: update ben_plip_f c
963: set c.elig_apls_flag = 'N'
964: where not exists
965: (select a.plip_id
966: from ben_prtn_elig_f a,
967: ben_prtn_elig_prfl_f b
968: where a.prtn_elig_id = b.prtn_elig_id
969: and a.plip_id = c.plip_id)
970: and not exists

Line 972: from ben_prtn_elig_f a,

968: where a.prtn_elig_id = b.prtn_elig_id
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;

Line 989: from ben_prtn_elig_f a,

985: update ben_ptip_f c
986: set c.elig_apls_flag = 'N'
987: where not exists
988: (select a.ptip_id
989: from ben_prtn_elig_f a,
990: ben_prtn_elig_prfl_f b
991: where a.prtn_elig_id = b.prtn_elig_id
992: and a.ptip_id = c.ptip_id)
993: and not exists

Line 995: from ben_prtn_elig_f a,

991: where a.prtn_elig_id = b.prtn_elig_id
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;

Line 1011: from ben_prtn_elig_f a,

1007: update ben_pl_f c
1008: set c.elig_apls_flag = 'N'
1009: where not exists
1010: (select a.pl_id
1011: from ben_prtn_elig_f a,
1012: ben_prtn_elig_prfl_f b
1013: where a.prtn_elig_id = b.prtn_elig_id
1014: and a.pl_id = c.pl_id)
1015: and not exists

Line 1017: from ben_prtn_elig_f a,

1013: where a.prtn_elig_id = b.prtn_elig_id
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;

Line 1034: from ben_prtn_elig_f a,

1030: update ben_oipl_f c
1031: set c.elig_apls_flag = 'N'
1032: where not exists
1033: (select a.oipl_id
1034: from ben_prtn_elig_f a,
1035: ben_prtn_elig_prfl_f b
1036: where a.prtn_elig_id = b.prtn_elig_id
1037: and a.oipl_id = c.oipl_id)
1038: and not exists

Line 1040: from ben_prtn_elig_f a,

1036: where a.prtn_elig_id = b.prtn_elig_id
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;

Line 1147: from ben_prtn_elig_f

1143: l_object_version_number number;
1144: --
1145: cursor c1 is
1146: select prtn_elig_id
1147: from ben_prtn_elig_f
1148: where ( pgm_id = p_pgm_id or p_pgm_id is null ) and
1149: ( pl_id = p_pl_id or p_pl_id is null ) and
1150: ( plip_id = p_plip_id or p_plip_id is null) and
1151: ( ptip_id = p_ptip_id or p_ptip_id is null) and