APPS.BEN_EXT_DPNT dependencies on BEN_PER_IN_LER

Line 155: from ben_per_in_ler pil

151: select pil.PER_IN_LER_STAT_CD,
152: pil.LF_EVT_OCRD_DT,
153: pil.NTFN_DT,
154: pil.LER_ID
155: from ben_per_in_ler pil
156: where pil.per_in_ler_id = p_per_in_ler_id ;
157:
158: l_per_in_ler_stat_cd ben_per_in_ler.PER_IN_LER_STAT_CD%Type ;
159: l_LF_EVT_OCRD_DT ben_per_in_ler.LF_EVT_OCRD_DT%type ;

Line 158: l_per_in_ler_stat_cd ben_per_in_ler.PER_IN_LER_STAT_CD%Type ;

154: pil.LER_ID
155: from ben_per_in_ler pil
156: where pil.per_in_ler_id = p_per_in_ler_id ;
157:
158: l_per_in_ler_stat_cd ben_per_in_ler.PER_IN_LER_STAT_CD%Type ;
159: l_LF_EVT_OCRD_DT ben_per_in_ler.LF_EVT_OCRD_DT%type ;
160: l_NTFN_DT ben_per_in_ler.NTFN_DT%type ;
161: l_ler_id ben_per_in_ler.ler_id%type ;
162:

Line 159: l_LF_EVT_OCRD_DT ben_per_in_ler.LF_EVT_OCRD_DT%type ;

155: from ben_per_in_ler pil
156: where pil.per_in_ler_id = p_per_in_ler_id ;
157:
158: l_per_in_ler_stat_cd ben_per_in_ler.PER_IN_LER_STAT_CD%Type ;
159: l_LF_EVT_OCRD_DT ben_per_in_ler.LF_EVT_OCRD_DT%type ;
160: l_NTFN_DT ben_per_in_ler.NTFN_DT%type ;
161: l_ler_id ben_per_in_ler.ler_id%type ;
162:
163:

Line 160: l_NTFN_DT ben_per_in_ler.NTFN_DT%type ;

156: where pil.per_in_ler_id = p_per_in_ler_id ;
157:
158: l_per_in_ler_stat_cd ben_per_in_ler.PER_IN_LER_STAT_CD%Type ;
159: l_LF_EVT_OCRD_DT ben_per_in_ler.LF_EVT_OCRD_DT%type ;
160: l_NTFN_DT ben_per_in_ler.NTFN_DT%type ;
161: l_ler_id ben_per_in_ler.ler_id%type ;
162:
163:
164:

Line 161: l_ler_id ben_per_in_ler.ler_id%type ;

157:
158: l_per_in_ler_stat_cd ben_per_in_ler.PER_IN_LER_STAT_CD%Type ;
159: l_LF_EVT_OCRD_DT ben_per_in_ler.LF_EVT_OCRD_DT%type ;
160: l_NTFN_DT ben_per_in_ler.NTFN_DT%type ;
161: l_ler_id ben_per_in_ler.ler_id%type ;
162:
163:
164:
165: