DBA Data[Home] [Help]

APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PER_PAY_BASES

Line 1377: per_pay_bases ppb

1373: cursor c_bases_element (cp_pay_basis_id in number,
1374: cp_period_to_date in date) is
1375: select piv.element_type_id, piv.input_value_id
1376: from pay_input_values_f piv,
1377: per_pay_bases ppb
1378: where ppb.pay_basis_id = cp_pay_basis_id
1379: and ppb.input_value_id = piv.input_value_id
1380: and cp_period_to_date between piv.effective_start_date
1381: and piv.effective_end_date;

Line 1494: from per_pay_bases ppb

1490: return number is
1491:
1492: cursor c_salary_details (cp_pay_basis_id in number) is
1493: select ppb.pay_annualization_factor
1494: from per_pay_bases ppb
1495: where ppb.pay_basis_id = cp_pay_basis_id;
1496:
1497: cursor c_payroll (cp_period_type in varchar2) is
1498: select ptpt.number_per_fiscal_year