APPS.BEN_DERIVABLE_RATE dependencies on BEN_ACTL_PREM_VRBL_RT_F

Line 202: ben_actl_prem_vrbl_rt_f apv

198: and (
199: exists (select null
200: from ben_age_rt_f art,
201: ben_actl_prem_f apr,
202: ben_actl_prem_vrbl_rt_f apv
203: where apr.'||p_col_name||' = :4
204: and apr.actl_prem_id = apv.actl_prem_id
205: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) or
206: exists (select null

Line 209: ben_actl_prem_vrbl_rt_f apv

205: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) or
206: exists (select null
207: from ben_cmbn_age_los_rt_f cmr,
208: ben_actl_prem_f apr,
209: ben_actl_prem_vrbl_rt_f apv
210: where apr.'||p_col_name||'= :5
211: and apr.actl_prem_id = apv.actl_prem_id
212: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) or
213: exists (select null

Line 216: ben_actl_prem_vrbl_rt_f apv

212: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) or
213: exists (select null
214: from ben_comp_lvl_rt_f clr,
215: ben_actl_prem_f apr,
216: ben_actl_prem_vrbl_rt_f apv
217: where apr.'||p_col_name||'= :6
218: and apr.actl_prem_id = apv.actl_prem_id
219: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) or
220: exists (select null

Line 223: ben_actl_prem_vrbl_rt_f apv

219: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) or
220: exists (select null
221: from ben_hrs_wkd_in_perd_rt_f hwr,
222: ben_actl_prem_f apr,
223: ben_actl_prem_vrbl_rt_f apv
224: where apr.'||p_col_name||'= :7
225: and apr.actl_prem_id = apv.actl_prem_id
226: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) or
227: exists (select null

Line 230: ben_actl_prem_vrbl_rt_f apv

226: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) or
227: exists (select null
228: from ben_los_rt_f lsr,
229: ben_actl_prem_f apr,
230: ben_actl_prem_vrbl_rt_f apv
231: where apr.'||p_col_name||'= :8
232: and apr.actl_prem_id = apv.actl_prem_id
233: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) or
234: exists (select null

Line 237: ben_actl_prem_vrbl_rt_f apv

233: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) or
234: exists (select null
235: from ben_pct_fl_tm_rt_f pfr,
236: ben_actl_prem_f apr,
237: ben_actl_prem_vrbl_rt_f apv
238: where apr.'||p_col_name||'= :9
239: and apr.actl_prem_id = apv.actl_prem_id
240: and apv.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id))';
241: --

Line 358: ben_actl_prem_vrbl_rt_f apv

354: l_strg := l_strg||' and
355: not exists (select null
356: from ben_age_rt_f art,
357: ben_actl_prem_f apr,
358: ben_actl_prem_vrbl_rt_f apv
359: where apr.'||p_col_name||' = :10
360: and apr.actl_prem_id = apv.actl_prem_id
361: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) and
362: not exists (select null

Line 365: ben_actl_prem_vrbl_rt_f apv

361: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) and
362: not exists (select null
363: from ben_cmbn_age_los_rt_f cmr,
364: ben_actl_prem_f apr,
365: ben_actl_prem_vrbl_rt_f apv
366: where apr.'||p_col_name||' = :11
367: and apr.actl_prem_id = apv.actl_prem_id
368: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) and
369: not exists (select null

Line 372: ben_actl_prem_vrbl_rt_f apv

368: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) and
369: not exists (select null
370: from ben_comp_lvl_rt_f clr,
371: ben_actl_prem_f apr,
372: ben_actl_prem_vrbl_rt_f apv
373: where apr.'||p_col_name||'= :12
374: and apr.actl_prem_id = apv.actl_prem_id
375: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) and
376: not exists (select null

Line 379: ben_actl_prem_vrbl_rt_f apv

375: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) and
376: not exists (select null
377: from ben_hrs_wkd_in_perd_rt_f hwr,
378: ben_actl_prem_f apr,
379: ben_actl_prem_vrbl_rt_f apv
380: where apr.'||p_col_name||'= :13
381: and apr.actl_prem_id = apv.actl_prem_id
382: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) and
383: not exists (select null

Line 386: ben_actl_prem_vrbl_rt_f apv

382: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) and
383: not exists (select null
384: from ben_los_rt_f lsr,
385: ben_actl_prem_f apr,
386: ben_actl_prem_vrbl_rt_f apv
387: where apr.'||p_col_name||'= :14
388: and apr.actl_prem_id = apv.actl_prem_id
389: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) and
390: not exists (select null

Line 393: ben_actl_prem_vrbl_rt_f apv

389: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) and
390: not exists (select null
391: from ben_pct_fl_tm_rt_f pfr,
392: ben_actl_prem_f apr,
393: ben_actl_prem_vrbl_rt_f apv
394: where apr.'||p_col_name||'= :15
395: and apr.actl_prem_id = apv.actl_prem_id
396: and apv.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)';
397: --

Line 507: ben_actl_prem_vrbl_rt_f apv

503: to_number(null) ptip_id,
504: to_number(null) plip_id,
505: oipl_id
506: from ben_actl_prem_f apr,
507: ben_actl_prem_vrbl_rt_f apv
508: where apr.actl_prem_id = apv.actl_prem_id
509: and apv.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
510: union
511: select to_number(null) pgm_id,

Line 696: ben_actl_prem_vrbl_rt_f apv

692: and avr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
693: and not exists (select null
694: from ben_age_rt_f art,
695: ben_actl_prem_f apr,
696: ben_actl_prem_vrbl_rt_f apv
697: where apr.pl_id = i.pl_id
698: and apr.actl_prem_id = apv.actl_prem_id
699: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
700: and not exists (select null

Line 703: ben_actl_prem_vrbl_rt_f apv

699: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
700: and not exists (select null
701: from ben_cmbn_age_los_rt_f cmr,
702: ben_actl_prem_f apr,
703: ben_actl_prem_vrbl_rt_f apv
704: where apr.pl_id = i.pl_id
705: and apr.actl_prem_id = apv.actl_prem_id
706: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
707: and not exists (select null

Line 710: ben_actl_prem_vrbl_rt_f apv

706: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
707: and not exists (select null
708: from ben_comp_lvl_rt_f clr,
709: ben_actl_prem_f apr,
710: ben_actl_prem_vrbl_rt_f apv
711: where apr.pl_id = i.pl_id
712: and apr.actl_prem_id = apv.actl_prem_id
713: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
714: and not exists (select null

Line 717: ben_actl_prem_vrbl_rt_f apv

713: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
714: and not exists (select null
715: from ben_hrs_wkd_in_perd_rt_f hwr,
716: ben_actl_prem_f apr,
717: ben_actl_prem_vrbl_rt_f apv
718: where apr.pl_id = i.pl_id
719: and apr.actl_prem_id = apv.actl_prem_id
720: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
721: and not exists (select null

Line 724: ben_actl_prem_vrbl_rt_f apv

720: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
721: and not exists (select null
722: from ben_los_rt_f lsr,
723: ben_actl_prem_f apr,
724: ben_actl_prem_vrbl_rt_f apv
725: where apr.pl_id = i.pl_id
726: and apr.actl_prem_id = apv.actl_prem_id
727: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
728: and not exists (select null

Line 731: ben_actl_prem_vrbl_rt_f apv

727: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
728: and not exists (select null
729: from ben_pct_fl_tm_rt_f pfr,
730: ben_actl_prem_f apr,
731: ben_actl_prem_vrbl_rt_f apv
732: where apr.pl_id = i.pl_id
733: and apr.actl_prem_id = apv.actl_prem_id
734: and apv.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
735: and not exists (select null

Line 975: ben_actl_prem_vrbl_rt_f apv

971: and avr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
972: and not exists (select null
973: from ben_age_rt_f art,
974: ben_actl_prem_f apr,
975: ben_actl_prem_vrbl_rt_f apv
976: where apr.oipl_id = i.oipl_id
977: and apr.actl_prem_id = apv.actl_prem_id
978: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
979: and not exists (select null

Line 982: ben_actl_prem_vrbl_rt_f apv

978: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
979: and not exists (select null
980: from ben_cmbn_age_los_rt_f cmr,
981: ben_actl_prem_f apr,
982: ben_actl_prem_vrbl_rt_f apv
983: where apr.oipl_id = i.oipl_id
984: and apr.actl_prem_id = apv.actl_prem_id
985: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
986: and not exists (select null

Line 989: ben_actl_prem_vrbl_rt_f apv

985: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
986: and not exists (select null
987: from ben_comp_lvl_rt_f clr,
988: ben_actl_prem_f apr,
989: ben_actl_prem_vrbl_rt_f apv
990: where apr.oipl_id = i.oipl_id
991: and apr.actl_prem_id = apv.actl_prem_id
992: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
993: and not exists (select null

Line 996: ben_actl_prem_vrbl_rt_f apv

992: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
993: and not exists (select null
994: from ben_hrs_wkd_in_perd_rt_f hwr,
995: ben_actl_prem_f apr,
996: ben_actl_prem_vrbl_rt_f apv
997: where apr.oipl_id = i.oipl_id
998: and apr.actl_prem_id = apv.actl_prem_id
999: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
1000: and not exists (select null

Line 1003: ben_actl_prem_vrbl_rt_f apv

999: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
1000: and not exists (select null
1001: from ben_los_rt_f lsr,
1002: ben_actl_prem_f apr,
1003: ben_actl_prem_vrbl_rt_f apv
1004: where apr.oipl_id = i.oipl_id
1005: and apr.actl_prem_id = apv.actl_prem_id
1006: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
1007: and not exists (select null

Line 1010: ben_actl_prem_vrbl_rt_f apv

1006: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
1007: and not exists (select null
1008: from ben_pct_fl_tm_rt_f pfr,
1009: ben_actl_prem_f apr,
1010: ben_actl_prem_vrbl_rt_f apv
1011: where apr.oipl_id = i.oipl_id
1012: and apr.actl_prem_id = apv.actl_prem_id
1013: and apv.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
1014: and not exists (select null