DBA Data[Home] [Help]

APPS.HRI_OPL_BEN_ENRL_ACTN dependencies on HRI_CS_COMPOBJ_CT

Line 463: hri_cs_compobj_ct copd_int,

459: l_due_dt_tab (i)
460: FROM ben_prtt_enrt_rslt_f pen,
461: hri_cs_time_benrl_prd_ct enpd,
462: ben_prtt_enrt_rslt_f pen_int,
463: hri_cs_compobj_ct copd_int,
464: hri_cs_compobj_ct copd,
465: ben_opt_f opt,
466: ben_pl_f pln
467: WHERE pen.per_in_ler_id = l_per_in_ler_id_tab (i)

Line 464: hri_cs_compobj_ct copd,

460: FROM ben_prtt_enrt_rslt_f pen,
461: hri_cs_time_benrl_prd_ct enpd,
462: ben_prtt_enrt_rslt_f pen_int,
463: hri_cs_compobj_ct copd_int,
464: hri_cs_compobj_ct copd,
465: ben_opt_f opt,
466: ben_pl_f pln
467: WHERE pen.per_in_ler_id = l_per_in_ler_id_tab (i)
468: AND pen.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id_tab (i)

Line 667: hri_cs_compobj_ct copd_int,

663: ben_prtt_enrt_actn_f pea,
664: hri_cs_time_benrl_prd_ct enpd,
665: ben_actn_typ act,
666: ben_prtt_enrt_rslt_f pen_int,
667: hri_cs_compobj_ct copd_int,
668: hri_cs_compobj_ct copd,
669: ben_opt_f opt,
670: ben_pl_f pln
671: WHERE pen.per_in_ler_id = p_pil_rec.per_in_ler_id

Line 668: hri_cs_compobj_ct copd,

664: hri_cs_time_benrl_prd_ct enpd,
665: ben_actn_typ act,
666: ben_prtt_enrt_rslt_f pen_int,
667: hri_cs_compobj_ct copd_int,
668: hri_cs_compobj_ct copd,
669: ben_opt_f opt,
670: ben_pl_f pln
671: WHERE pen.per_in_ler_id = p_pil_rec.per_in_ler_id
672: AND pen.prtt_enrt_rslt_id = pea.prtt_enrt_rslt_id