APPS.BEN_CWB_UTILS dependencies on BEN_TRANSACTION

Line 2640: l_asgn_flex ben_transaction.attribute11%Type;

2636: p_asg_updt_eff_date in date,
2637: p_asg_flex_num in number
2638: ) return varchar2 IS
2639:
2640: l_asgn_flex ben_transaction.attribute11%Type;
2641: begin
2642: populate_asgn_txn_rec (p_assignment_id, p_asg_updt_eff_date);
2643:
2644: if (p_asg_flex_num = 1) then

Line 2717: From ben_transaction

2713: p_emp_interview_typ_cd in varchar2 ) return varchar2 IS
2714:
2715: CURSOR c_perf_rate is
2716: select hr_general.decode_lookup('PERFORMANCE_RATING',attribute3)
2717: From ben_transaction
2718: where transaction_id = p_assignment_id
2719: and transaction_type = 'CWBPERF'||to_char(p_perf_revw_strt_dt,'rrrr/mm/dd')
2720: ||p_emp_interview_typ_cd;
2721:

Line 2722: l_perf_rating ben_transaction.attribute3%Type;

2718: where transaction_id = p_assignment_id
2719: and transaction_type = 'CWBPERF'||to_char(p_perf_revw_strt_dt,'rrrr/mm/dd')
2720: ||p_emp_interview_typ_cd;
2721:
2722: l_perf_rating ben_transaction.attribute3%Type;
2723: begin
2724: open c_perf_rate;
2725: fetch c_perf_rate into l_perf_rating;
2726: close c_perf_rate;