eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_EMP_ACTION_ARCH dependencies on PER_PAY_BASES

Line 575: per_pay_bases ppb

571: cursor c_bases_element (cp_pay_basis_id in number,
572: cp_date_earned in date) is
573: select piv.element_type_id, piv.input_value_id
574: from pay_input_values_f piv,
575: per_pay_bases ppb
576: where ppb.pay_basis_id = cp_pay_basis_id
577: and ppb.input_value_id = piv.input_value_id
578: and cp_date_earned between piv.effective_start_date
579: and piv.effective_end_date;

Line 694: from per_pay_bases ppb

690: return number is
691:
692: cursor c_salary_details (cp_pay_basis_id in number) is
693: select ppb.pay_annualization_factor
694: from per_pay_bases ppb
695: where ppb.pay_basis_id = cp_pay_basis_id;
696:
697: cursor c_payroll (cp_period_type in varchar2) is
698: select ptpt.number_per_fiscal_year

Line 1412: from per_pay_bases ppb,

1408:
1409: cursor c_pay_basis(cp_pay_basis_id in number
1410: ,cp_effective_date in date) is
1411: select ppb.name
1412: from per_pay_bases ppb,
1413: pay_input_values_f piv
1414: where ppb.pay_basis_id = cp_pay_basis_id
1415: and piv.input_value_id = ppb.input_value_id
1416: and p_effective_date between piv.effective_start_date