DBA Data[Home] [Help]

APPS.BEN_CWB_UTILS dependencies on PER_PAY_BASES

Line 1870: from per_pay_bases ppb,

1866: p_ws_sub_acty_typ_cd in varchar2) return Varchar2 is
1867:
1868: Cursor c_pay_rate_basis is
1869: select initcap(pay_basis)
1870: from per_pay_bases ppb,
1871: per_all_assignments_f paaf
1872: where ppb.pay_basis_id = paaf.pay_basis_id
1873: and sysdate between paaf.effective_start_date and paaf.effective_end_date
1874: and paaf.primary_flag = 'Y'

Line 1877: l_pay_basis per_pay_bases.pay_basis%Type;

1873: and sysdate between paaf.effective_start_date and paaf.effective_end_date
1874: and paaf.primary_flag = 'Y'
1875: and paaf.assignment_id = g_person_rates_rec.assignment_id;
1876:
1877: l_pay_basis per_pay_bases.pay_basis%Type;
1878: BEGIN
1879:
1880: populate_person_rates_rec (
1881: p_group_plan_id,p_lf_evnt_ocrd_dt,