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

Line 1623: l_units_mean hr_lookups.meaning%type;

1619: -- Local variables added as part of tiem analysis changes
1620: l_con_fixed_working_time per_contracts_f.ctr_information10%type;
1621: l_amount per_contracts_f.ctr_information11%type;
1622: l_units per_contracts_f.ctr_information12%type;
1623: l_units_mean hr_lookups.meaning%type;
1624: l_frequency per_contracts_f.ctr_information13%type;
1625: l_freq_mean hr_lookups.meaning%type;
1626: --
1627: -- csr_ee_address Gets the employees primary address

Line 1625: l_freq_mean hr_lookups.meaning%type;

1621: l_amount per_contracts_f.ctr_information11%type;
1622: l_units per_contracts_f.ctr_information12%type;
1623: l_units_mean hr_lookups.meaning%type;
1624: l_frequency per_contracts_f.ctr_information13%type;
1625: l_freq_mean hr_lookups.meaning%type;
1626: --
1627: -- csr_ee_address Gets the employees primary address
1628: --
1629: cursor csr_ee_address (p_person_id number, p_asat_date date) is

Line 2140: ,hr_lookups bank

2136: ,substr(pxa.segment2, 1, 5) bank_code
2137: ,substr(pxa.segment3, 1, 5) branch_code
2138: ,substr(pxa.segment5, 1, 14) account_number
2139: from pay_external_accounts pxa
2140: ,hr_lookups bank
2141: where bank.lookup_type(+) = 'FR_BANK'
2142: and bank.lookup_code(+) = pxa.segment1
2143: and pxa.external_account_id = p_account_id;
2144: --