APPS.BEN_CWB_UTILS dependencies on PER_PAY_BASES

Line 2377: from per_pay_bases ppb,

2373: p_ws_sub_acty_typ_cd in varchar2) return Varchar2 is
2374:
2375: Cursor c_pay_rate_basis is
2376: select initcap(pay_basis)
2377: from per_pay_bases ppb,
2378: per_all_assignments_f paaf
2379: where ppb.pay_basis_id = paaf.pay_basis_id
2380: and sysdate between paaf.effective_start_date and paaf.effective_end_date
2381: and paaf.primary_flag = 'Y'

Line 2384: l_pay_basis per_pay_bases.pay_basis%Type;

2380: and sysdate between paaf.effective_start_date and paaf.effective_end_date
2381: and paaf.primary_flag = 'Y'
2382: and paaf.assignment_id = g_person_rates_rec.assignment_id;
2383:
2384: l_pay_basis per_pay_bases.pay_basis%Type;
2385: BEGIN
2386:
2387: populate_person_rates_rec (
2388: p_group_plan_id,p_lf_evnt_ocrd_dt,