DBA Data[Home] [Help]

APPS.BEN_DM_UPLOAD_DK dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 955: from ben_popl_enrt_typ_cycl_f

951: and target_id is null;
952:
953: cursor csr_get_dk_pop (c_pgm_id number, c_pl_id number, c_business_group_id number) is
954: select *
955: from ben_popl_enrt_typ_cycl_f
956: where nvl(pgm_id,-1) = nvl(c_pgm_id,-1)
957: and nvl(pl_id,-1) = nvl(c_pl_id,-1)
958: and business_group_id = c_business_group_id
959: order by decode(enrt_typ_cycl_cd,'O',1,2) asc;

Line 1057: from ben_popl_enrt_typ_cycl_f

1053: and target_id is null;
1054:
1055: cursor csr_get_dk_pop (c_pgm_id number, c_pl_id number, c_business_group_id number) is
1056: select *
1057: from ben_popl_enrt_typ_cycl_f
1058: where nvl(pgm_id,-1) = nvl(c_pgm_id,-1)
1059: and nvl(pl_id,-1) = nvl(c_pl_id,-1)
1060: and business_group_id = c_business_group_id
1061: and enrt_typ_cycl_cd = 'L';