DBA Data[Home] [Help]

APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PER_PAY_BASES

Line 789: per_pay_bases ppb

785: cursor c_bases_element (cp_pay_basis_id in number,
786: cp_period_to_date in date) is
787: select piv.element_type_id, piv.input_value_id
788: from pay_input_values_f piv,
789: per_pay_bases ppb
790: where ppb.pay_basis_id = cp_pay_basis_id
791: and ppb.input_value_id = piv.input_value_id
792: and cp_period_to_date between piv.effective_start_date
793: and piv.effective_end_date;

Line 906: from per_pay_bases ppb

902: return number is
903:
904: cursor c_salary_details (cp_pay_basis_id in number) is
905: select ppb.pay_annualization_factor
906: from per_pay_bases ppb
907: where ppb.pay_basis_id = cp_pay_basis_id;
908:
909: cursor c_payroll (cp_period_type in varchar2) is
910: select ptpt.number_per_fiscal_year