APPS.BEN_PRC_BUS dependencies on BEN_PRTT_RT_VAL

Line 127: from ben_prtt_rt_val

123: and yrp.business_group_id = p_business_group_id;
124: --
125: cursor c_prv is
126: select acty_base_rt_id
127: from ben_prtt_rt_val
128: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
129: and prtt_reimbmt_rqst_id is null ;
130:
131: l_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%type ;

Line 157: from ben_prtt_rt_val prv,

153: cursor c_abr_prv is
154: select distinct prv.acty_base_rt_id prv_rate,
155: abr.name abr_name,
156: clf.*
157: from ben_prtt_rt_val prv,
158: ben_acty_base_rt_f abr,
159: ben_comp_lvl_fctr clf
160: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
161: and prv.acty_base_rt_id = abr.acty_base_rt_id

Line 1526: from ben_prtt_rt_val

1522:
1523:
1524: cursor c_prv is
1525: select acty_base_rt_id , rt_strt_dt
1526: from ben_prtt_rt_val
1527: where prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id ;
1528:
1529:
1530:

Line 2139: from ben_prtt_rt_val a

2135: l_dummy varchar2(1);
2136:
2137: cursor c1 is
2138: select null
2139: from ben_prtt_rt_val a
2140: where a.prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id;
2141:
2142: Begin
2143: hr_utility.set_location('Entering:'||l_proc,5);

Line 2145: -- check if child rows exists in ben_prtt_rt_val.

2141:
2142: Begin
2143: hr_utility.set_location('Entering:'||l_proc,5);
2144: --
2145: -- check if child rows exists in ben_prtt_rt_val.
2146: --
2147: open c1;
2148: fetch c1 into l_dummy;
2149: if c1%found then

Line 2244: l_table_name := 'ben_prtt_rt_val';

2240: p_argument => 'prtt_reimbmt_rqst_id',
2241: p_argument_value => p_prtt_reimbmt_rqst_id);
2242: --
2243: If (prv_rows_exists(p_prtt_reimbmt_rqst_id => p_prtt_reimbmt_rqst_id)) Then
2244: l_table_name := 'ben_prtt_rt_val';
2245: Raise l_rows_exist;
2246: End If;
2247: End If;
2248: --