DBA Data[Home] [Help]

APPS.BEN_GENERATE_DPNT_COMM dependencies on BEN_PRTT_RT_VAL

Line 1092: ben_prtt_rt_val prv

1088: from ben_cm_typ_usg_f ctu,
1089: ben_prtt_enrt_rslt_f pen,
1090: ben_enrt_perd enp,
1091: ben_popl_enrt_typ_cycl_f pet,
1092: ben_prtt_rt_val prv
1093: where ctu.business_group_id = p_business_group_id
1094: /* First join comp objects */
1095: and prv.business_group_id = ctu.business_group_id
1096: and prv.per_in_ler_id = p_per_in_ler_id

Line 1153: ben_prtt_rt_val prv

1149: --
1150: cursor c_bnf_always is
1151: select null
1152: from ben_prtt_enrt_rslt_f pen,
1153: ben_prtt_rt_val prv
1154: where prv.business_group_id = p_business_group_id
1155: and prv.per_in_ler_id = p_per_in_ler_id
1156: and prv.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1157: and prv.prtt_rt_val_stat_cd is null

Line 1181: ben_prtt_rt_val prv

1177: from ben_cm_typ_usg_f ctu,
1178: ben_prtt_enrt_rslt_f pen,
1179: ben_enrt_perd enp,
1180: ben_popl_enrt_typ_cycl_f pet,
1181: ben_prtt_rt_val prv
1182: where ctu.business_group_id = p_business_group_id
1183: /* First join comp objects */
1184: and prv.business_group_id = ctu.business_group_id
1185: and prv.per_in_ler_id = p_per_in_ler_id

Line 1243: ben_prtt_rt_val prv

1239: --
1240: cursor c_dpnt_always is
1241: select null
1242: from ben_prtt_enrt_rslt_f pen,
1243: ben_prtt_rt_val prv
1244: where prv.business_group_id = p_business_group_id
1245: and prv.per_in_ler_id = p_per_in_ler_id
1246: and prv.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1247: and prv.prtt_rt_val_stat_cd is null