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 273: FROM hr_lookups

269:
270: CURSOR cur_filing_status_meaning(p_state_code VARCHAR2
271: ,p_filing_status_code VARCHAR2) IS
272: SELECT meaning
273: FROM hr_lookups
274: WHERE lookup_type = 'US_FS_'||p_state_code
275: AND lpad(lookup_code,2,'0') = p_filing_status_code
276: AND application_id = 800
277: AND enabled_flag = 'Y';

Line 280: lv_fed_03_meaning hr_lookups.meaning%TYPE;

276: AND application_id = 800
277: AND enabled_flag = 'Y';
278:
279: lv_state_name pay_us_states.state_name%TYPE;
280: lv_fed_03_meaning hr_lookups.meaning%TYPE;
281: lv_state_fs_meaning hr_lookups.meaning%TYPE;
282: lv_state_04_fs_meaning hr_lookups.meaning%TYPE;
283:
284: BEGIN

Line 281: lv_state_fs_meaning hr_lookups.meaning%TYPE;

277: AND enabled_flag = 'Y';
278:
279: lv_state_name pay_us_states.state_name%TYPE;
280: lv_fed_03_meaning hr_lookups.meaning%TYPE;
281: lv_state_fs_meaning hr_lookups.meaning%TYPE;
282: lv_state_04_fs_meaning hr_lookups.meaning%TYPE;
283:
284: BEGIN
285: hr_utility.trace('Entering Into '||gv_package_name||'.Fed_State_Filing_Status_Match');

Line 282: lv_state_04_fs_meaning hr_lookups.meaning%TYPE;

278:
279: lv_state_name pay_us_states.state_name%TYPE;
280: lv_fed_03_meaning hr_lookups.meaning%TYPE;
281: lv_state_fs_meaning hr_lookups.meaning%TYPE;
282: lv_state_04_fs_meaning hr_lookups.meaning%TYPE;
283:
284: BEGIN
285: hr_utility.trace('Entering Into '||gv_package_name||'.Fed_State_Filing_Status_Match');
286: hr_utility.trace('p_state_code := '||p_state_code);