APPS.BEN_CWB_UTILS dependencies on BEN_TRANSACTION

Line 2133: l_asgn_flex ben_transaction.attribute11%Type;

2129: p_asg_updt_eff_date in date,
2130: p_asg_flex_num in number
2131: ) return varchar2 IS
2132:
2133: l_asgn_flex ben_transaction.attribute11%Type;
2134: begin
2135: populate_asgn_txn_rec (p_assignment_id, p_asg_updt_eff_date);
2136:
2137: if (p_asg_flex_num = 1) then

Line 2210: From ben_transaction

2206: p_emp_interview_typ_cd in varchar2 ) return varchar2 IS
2207:
2208: CURSOR c_perf_rate is
2209: select hr_general.decode_lookup('PERFORMANCE_RATING',attribute3)
2210: From ben_transaction
2211: where transaction_id = p_assignment_id
2212: and transaction_type = 'CWBPERF'||to_char(p_perf_revw_strt_dt,'rrrr/mm/dd')
2213: ||p_emp_interview_typ_cd;
2214:

Line 2215: l_perf_rating ben_transaction.attribute3%Type;

2211: where transaction_id = p_assignment_id
2212: and transaction_type = 'CWBPERF'||to_char(p_perf_revw_strt_dt,'rrrr/mm/dd')
2213: ||p_emp_interview_typ_cd;
2214:
2215: l_perf_rating ben_transaction.attribute3%Type;
2216: begin
2217: open c_perf_rate;
2218: fetch c_perf_rate into l_perf_rating;
2219: close c_perf_rate;