APPS.BEN_DERIVABLE_RATE dependencies on BEN_ACTL_PREM_F

Line 189: ben_actl_prem_f apr,

185: drvbl_fctr_apls_rts_flag = :3
186: and (
187: exists (select null
188: from ben_age_rt_f art,
189: ben_actl_prem_f apr,
190: ben_actl_prem_vrbl_rt_f apv
191: where apr.'||p_col_name||' = :4
192: and apr.actl_prem_id = apv.actl_prem_id
193: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) or

Line 196: ben_actl_prem_f apr,

192: and apr.actl_prem_id = apv.actl_prem_id
193: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) or
194: exists (select null
195: from ben_cmbn_age_los_rt_f cmr,
196: ben_actl_prem_f apr,
197: ben_actl_prem_vrbl_rt_f apv
198: where apr.'||p_col_name||'= :5
199: and apr.actl_prem_id = apv.actl_prem_id
200: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) or

Line 203: ben_actl_prem_f apr,

199: and apr.actl_prem_id = apv.actl_prem_id
200: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) or
201: exists (select null
202: from ben_comp_lvl_rt_f clr,
203: ben_actl_prem_f apr,
204: ben_actl_prem_vrbl_rt_f apv
205: where apr.'||p_col_name||'= :6
206: and apr.actl_prem_id = apv.actl_prem_id
207: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) or

Line 210: ben_actl_prem_f apr,

206: and apr.actl_prem_id = apv.actl_prem_id
207: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) or
208: exists (select null
209: from ben_hrs_wkd_in_perd_rt_f hwr,
210: ben_actl_prem_f apr,
211: ben_actl_prem_vrbl_rt_f apv
212: where apr.'||p_col_name||'= :7
213: and apr.actl_prem_id = apv.actl_prem_id
214: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) or

Line 217: ben_actl_prem_f apr,

213: and apr.actl_prem_id = apv.actl_prem_id
214: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) or
215: exists (select null
216: from ben_los_rt_f lsr,
217: ben_actl_prem_f apr,
218: ben_actl_prem_vrbl_rt_f apv
219: where apr.'||p_col_name||'= :8
220: and apr.actl_prem_id = apv.actl_prem_id
221: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) or

Line 224: ben_actl_prem_f apr,

220: and apr.actl_prem_id = apv.actl_prem_id
221: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) or
222: exists (select null
223: from ben_pct_fl_tm_rt_f pfr,
224: ben_actl_prem_f apr,
225: ben_actl_prem_vrbl_rt_f apv
226: where apr.'||p_col_name||'= :9
227: and apr.actl_prem_id = apv.actl_prem_id
228: and apv.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id))';

Line 345: ben_actl_prem_f apr,

341: --
342: l_strg := l_strg||' and
343: not exists (select null
344: from ben_age_rt_f art,
345: ben_actl_prem_f apr,
346: ben_actl_prem_vrbl_rt_f apv
347: where apr.'||p_col_name||' = :10
348: and apr.actl_prem_id = apv.actl_prem_id
349: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) and

Line 352: ben_actl_prem_f apr,

348: and apr.actl_prem_id = apv.actl_prem_id
349: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) and
350: not exists (select null
351: from ben_cmbn_age_los_rt_f cmr,
352: ben_actl_prem_f apr,
353: ben_actl_prem_vrbl_rt_f apv
354: where apr.'||p_col_name||' = :11
355: and apr.actl_prem_id = apv.actl_prem_id
356: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) and

Line 359: ben_actl_prem_f apr,

355: and apr.actl_prem_id = apv.actl_prem_id
356: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) and
357: not exists (select null
358: from ben_comp_lvl_rt_f clr,
359: ben_actl_prem_f apr,
360: ben_actl_prem_vrbl_rt_f apv
361: where apr.'||p_col_name||'= :12
362: and apr.actl_prem_id = apv.actl_prem_id
363: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) and

Line 366: ben_actl_prem_f apr,

362: and apr.actl_prem_id = apv.actl_prem_id
363: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) and
364: not exists (select null
365: from ben_hrs_wkd_in_perd_rt_f hwr,
366: ben_actl_prem_f apr,
367: ben_actl_prem_vrbl_rt_f apv
368: where apr.'||p_col_name||'= :13
369: and apr.actl_prem_id = apv.actl_prem_id
370: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) and

Line 373: ben_actl_prem_f apr,

369: and apr.actl_prem_id = apv.actl_prem_id
370: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) and
371: not exists (select null
372: from ben_los_rt_f lsr,
373: ben_actl_prem_f apr,
374: ben_actl_prem_vrbl_rt_f apv
375: where apr.'||p_col_name||'= :14
376: and apr.actl_prem_id = apv.actl_prem_id
377: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) and

Line 380: ben_actl_prem_f apr,

376: and apr.actl_prem_id = apv.actl_prem_id
377: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) and
378: not exists (select null
379: from ben_pct_fl_tm_rt_f pfr,
380: ben_actl_prem_f apr,
381: ben_actl_prem_vrbl_rt_f apv
382: where apr.'||p_col_name||'= :15
383: and apr.actl_prem_id = apv.actl_prem_id
384: and apv.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)';

Line 494: from ben_actl_prem_f apr,

490: pl_id,
491: to_number(null) ptip_id,
492: to_number(null) plip_id,
493: oipl_id
494: from ben_actl_prem_f apr,
495: ben_actl_prem_vrbl_rt_f apv
496: where apr.actl_prem_id = apv.actl_prem_id
497: and apv.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
498: union

Line 683: ben_actl_prem_f apr,

679: and abr.acty_base_rt_id = avr.acty_base_rt_id
680: and avr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
681: and not exists (select null
682: from ben_age_rt_f art,
683: ben_actl_prem_f apr,
684: ben_actl_prem_vrbl_rt_f apv
685: where apr.pl_id = i.pl_id
686: and apr.actl_prem_id = apv.actl_prem_id
687: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)

Line 690: ben_actl_prem_f apr,

686: and apr.actl_prem_id = apv.actl_prem_id
687: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
688: and not exists (select null
689: from ben_cmbn_age_los_rt_f cmr,
690: ben_actl_prem_f apr,
691: ben_actl_prem_vrbl_rt_f apv
692: where apr.pl_id = i.pl_id
693: and apr.actl_prem_id = apv.actl_prem_id
694: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)

Line 697: ben_actl_prem_f apr,

693: and apr.actl_prem_id = apv.actl_prem_id
694: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
695: and not exists (select null
696: from ben_comp_lvl_rt_f clr,
697: ben_actl_prem_f apr,
698: ben_actl_prem_vrbl_rt_f apv
699: where apr.pl_id = i.pl_id
700: and apr.actl_prem_id = apv.actl_prem_id
701: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)

Line 704: ben_actl_prem_f apr,

700: and apr.actl_prem_id = apv.actl_prem_id
701: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
702: and not exists (select null
703: from ben_hrs_wkd_in_perd_rt_f hwr,
704: ben_actl_prem_f apr,
705: ben_actl_prem_vrbl_rt_f apv
706: where apr.pl_id = i.pl_id
707: and apr.actl_prem_id = apv.actl_prem_id
708: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)

Line 711: ben_actl_prem_f apr,

707: and apr.actl_prem_id = apv.actl_prem_id
708: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
709: and not exists (select null
710: from ben_los_rt_f lsr,
711: ben_actl_prem_f apr,
712: ben_actl_prem_vrbl_rt_f apv
713: where apr.pl_id = i.pl_id
714: and apr.actl_prem_id = apv.actl_prem_id
715: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)

Line 718: ben_actl_prem_f apr,

714: and apr.actl_prem_id = apv.actl_prem_id
715: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
716: and not exists (select null
717: from ben_pct_fl_tm_rt_f pfr,
718: ben_actl_prem_f apr,
719: ben_actl_prem_vrbl_rt_f apv
720: where apr.pl_id = i.pl_id
721: and apr.actl_prem_id = apv.actl_prem_id
722: and apv.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)

Line 962: ben_actl_prem_f apr,

958: and abr.acty_base_rt_id = avr.acty_base_rt_id
959: and avr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
960: and not exists (select null
961: from ben_age_rt_f art,
962: ben_actl_prem_f apr,
963: ben_actl_prem_vrbl_rt_f apv
964: where apr.oipl_id = i.oipl_id
965: and apr.actl_prem_id = apv.actl_prem_id
966: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)

Line 969: ben_actl_prem_f apr,

965: and apr.actl_prem_id = apv.actl_prem_id
966: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
967: and not exists (select null
968: from ben_cmbn_age_los_rt_f cmr,
969: ben_actl_prem_f apr,
970: ben_actl_prem_vrbl_rt_f apv
971: where apr.oipl_id = i.oipl_id
972: and apr.actl_prem_id = apv.actl_prem_id
973: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)

Line 976: ben_actl_prem_f apr,

972: and apr.actl_prem_id = apv.actl_prem_id
973: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
974: and not exists (select null
975: from ben_comp_lvl_rt_f clr,
976: ben_actl_prem_f apr,
977: ben_actl_prem_vrbl_rt_f apv
978: where apr.oipl_id = i.oipl_id
979: and apr.actl_prem_id = apv.actl_prem_id
980: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)

Line 983: ben_actl_prem_f apr,

979: and apr.actl_prem_id = apv.actl_prem_id
980: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
981: and not exists (select null
982: from ben_hrs_wkd_in_perd_rt_f hwr,
983: ben_actl_prem_f apr,
984: ben_actl_prem_vrbl_rt_f apv
985: where apr.oipl_id = i.oipl_id
986: and apr.actl_prem_id = apv.actl_prem_id
987: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)

Line 990: ben_actl_prem_f apr,

986: and apr.actl_prem_id = apv.actl_prem_id
987: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
988: and not exists (select null
989: from ben_los_rt_f lsr,
990: ben_actl_prem_f apr,
991: ben_actl_prem_vrbl_rt_f apv
992: where apr.oipl_id = i.oipl_id
993: and apr.actl_prem_id = apv.actl_prem_id
994: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)

Line 997: ben_actl_prem_f apr,

993: and apr.actl_prem_id = apv.actl_prem_id
994: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
995: and not exists (select null
996: from ben_pct_fl_tm_rt_f pfr,
997: ben_actl_prem_f apr,
998: ben_actl_prem_vrbl_rt_f apv
999: where apr.oipl_id = i.oipl_id
1000: and apr.actl_prem_id = apv.actl_prem_id
1001: and apv.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)