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 614: per_pay_bases ppb

610: cursor c_bases_element (cp_pay_basis_id in number,
611: cp_date_earned in date) is
612: select piv.element_type_id, piv.input_value_id
613: from pay_input_values_f piv,
614: per_pay_bases ppb
615: where ppb.pay_basis_id = cp_pay_basis_id
616: and ppb.input_value_id = piv.input_value_id
617: and cp_date_earned between piv.effective_start_date
618: and piv.effective_end_date;

Line 733: from per_pay_bases ppb

729: return number is
730:
731: cursor c_salary_details (cp_pay_basis_id in number) is
732: select ppb.pay_annualization_factor
733: from per_pay_bases ppb
734: where ppb.pay_basis_id = cp_pay_basis_id;
735:
736: cursor c_payroll (cp_period_type in varchar2) is
737: select ptpt.number_per_fiscal_year

Line 1482: from per_pay_bases ppb,

1478:
1479: cursor c_pay_basis(cp_pay_basis_id in number
1480: ,cp_effective_date in date) is
1481: select ppb.name
1482: from per_pay_bases ppb,
1483: pay_input_values_f piv
1484: where ppb.pay_basis_id = cp_pay_basis_id
1485: and piv.input_value_id = ppb.input_value_id
1486: and p_effective_date between piv.effective_start_date