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_PAYSGI21_XMLP_PKG dependencies on HR_LOOKUPS

Line 243: v_pay_basis hr_lookups.meaning%TYPE;

239: end;
240:
241: --function cf_pay_basisformula(organization_id in varchar2, person_id in number, actual_termination_date in date) return char is
242: function cf_pay_basisformula(organization_id_v in varchar2, person_id in number, actual_termination_date in date) return char is
243: v_pay_basis hr_lookups.meaning%TYPE;
244:
245: cursor c_pay_basis is
246: select hl.meaning pay_basis
247: from hr_organization_units hou,

Line 251: hr_lookups hl

247: from hr_organization_units hou,
248: hr_soft_coding_keyflex hsc,
249: per_assignments_f paaf,
250: per_pay_bases ppb,
251: hr_lookups hl
252: where to_char(hou.organization_id) = hsc.segment1
253: and hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
254: and paaf.pay_basis_id = ppb.pay_basis_id
255: and ppb.pay_basis = hl.lookup_code