DBA Data[Home] [Help]

APPS.BEN_SUM dependencies on BEN_ELIG_PER_F

Line 48: from ben_elig_per_f pep,

44: pep.elig_flag yn_lookcd,
45: 'PGM' type
46: ,
47: pgm.pgm_typ_cd object_type_cd
48: from ben_elig_per_f pep,
49: ben_per_in_ler pil,
50: ben_pgm_f pgm
51: WHERE pep.person_id = c_per_id
52: and pep.pgm_id = pgm.pgm_id

Line 77: from ben_elig_per_f pep ,

73: pep.elig_flag yn_lookcd,
74: 'PL' type
75: ,
76: pl.svgs_pl_flag object_type_cd
77: from ben_elig_per_f pep ,
78: ben_per_in_ler pil,
79: ben_pl_f pl
80: WHERE pep.person_id = c_per_id
81: and pep.pl_id = pl.pl_id

Line 109: ben_elig_per_f pep ,

105: 'OPT' type
106: ,
107: null object_type_cd
108: from ben_elig_per_opt_f pio ,
109: ben_elig_per_f pep ,
110: ben_per_in_ler pil,
111: ben_pl_f pl ,
112: ben_opt_f opt
113: WHERE pep.person_id = c_per_id

Line 144: from ben_elig_per_f pep ,

140: pep.elig_flag yn_lookcd,
141: 'PL' type
142: ,
143: pl.svgs_pl_flag object_type_cd
144: from ben_elig_per_f pep ,
145: ben_per_in_ler pil,
146: ben_pl_f pl
147: WHERE pep.person_id = c_per_id
148: and pep.pl_id = pl.pl_id

Line 174: ben_elig_per_f pep ,

170: 'OPT' type
171: ,
172: null object_type_cd
173: from ben_elig_per_opt_f pio ,
174: ben_elig_per_f pep ,
175: ben_per_in_ler pil,
176: ben_pl_f pl ,
177: ben_opt_f opt
178: WHERE pep.person_id = c_per_id