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

Line 235: FROM hr_lookups

231:
232: CURSOR cur_filing_status_meaning(p_state_code VARCHAR2
233: ,p_filing_status_code VARCHAR2) IS
234: SELECT meaning
235: FROM hr_lookups
236: WHERE lookup_type = 'US_FS_'||p_state_code
237: AND lpad(lookup_code,2,'0') = p_filing_status_code
238: AND application_id = 800
239: AND enabled_flag = 'Y';

Line 242: lv_fed_03_meaning hr_lookups.meaning%TYPE;

238: AND application_id = 800
239: AND enabled_flag = 'Y';
240:
241: lv_state_name pay_us_states.state_name%TYPE;
242: lv_fed_03_meaning hr_lookups.meaning%TYPE;
243: lv_state_fs_meaning hr_lookups.meaning%TYPE;
244: lv_state_04_fs_meaning hr_lookups.meaning%TYPE;
245:
246: BEGIN

Line 243: lv_state_fs_meaning hr_lookups.meaning%TYPE;

239: AND enabled_flag = 'Y';
240:
241: lv_state_name pay_us_states.state_name%TYPE;
242: lv_fed_03_meaning hr_lookups.meaning%TYPE;
243: lv_state_fs_meaning hr_lookups.meaning%TYPE;
244: lv_state_04_fs_meaning hr_lookups.meaning%TYPE;
245:
246: BEGIN
247: hr_utility.trace('Entering Into '||gv_package_name||'.Fed_State_Filing_Status_Match');

Line 244: lv_state_04_fs_meaning hr_lookups.meaning%TYPE;

240:
241: lv_state_name pay_us_states.state_name%TYPE;
242: lv_fed_03_meaning hr_lookups.meaning%TYPE;
243: lv_state_fs_meaning hr_lookups.meaning%TYPE;
244: lv_state_04_fs_meaning hr_lookups.meaning%TYPE;
245:
246: BEGIN
247: hr_utility.trace('Entering Into '||gv_package_name||'.Fed_State_Filing_Status_Match');
248: hr_utility.trace('p_state_code := '||p_state_code);