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.HR_US_W2_MT dependencies on FF_USER_ENTITIES

Line 373: from ff_user_entities

369: l_juri_context ff_contexts.context_id%TYPE;
370:
371: CURSOR c_state_ueid (p_user_entity_name varchar2) is
372: select user_entity_id
373: from ff_user_entities
374: where user_entity_name = p_user_entity_name
375: and legislation_code = 'US';
376:
377: l_city_wk_whld ff_user_entities.user_entity_name%TYPE;

Line 377: l_city_wk_whld ff_user_entities.user_entity_name%TYPE;

373: from ff_user_entities
374: where user_entity_name = p_user_entity_name
375: and legislation_code = 'US';
376:
377: l_city_wk_whld ff_user_entities.user_entity_name%TYPE;
378: l_subj_whable ff_user_entities.user_entity_name%TYPE;
379: l_subj_nwhable ff_user_entities.user_entity_name%TYPE;
380: l_county_wheld ff_user_entities.user_entity_name%TYPE;
381: l_school_wheld ff_user_entities.user_entity_name%TYPE;

Line 378: l_subj_whable ff_user_entities.user_entity_name%TYPE;

374: where user_entity_name = p_user_entity_name
375: and legislation_code = 'US';
376:
377: l_city_wk_whld ff_user_entities.user_entity_name%TYPE;
378: l_subj_whable ff_user_entities.user_entity_name%TYPE;
379: l_subj_nwhable ff_user_entities.user_entity_name%TYPE;
380: l_county_wheld ff_user_entities.user_entity_name%TYPE;
381: l_school_wheld ff_user_entities.user_entity_name%TYPE;
382:

Line 379: l_subj_nwhable ff_user_entities.user_entity_name%TYPE;

375: and legislation_code = 'US';
376:
377: l_city_wk_whld ff_user_entities.user_entity_name%TYPE;
378: l_subj_whable ff_user_entities.user_entity_name%TYPE;
379: l_subj_nwhable ff_user_entities.user_entity_name%TYPE;
380: l_county_wheld ff_user_entities.user_entity_name%TYPE;
381: l_school_wheld ff_user_entities.user_entity_name%TYPE;
382:
383: TYPE RefCurType is REF CURSOR;

Line 380: l_county_wheld ff_user_entities.user_entity_name%TYPE;

376:
377: l_city_wk_whld ff_user_entities.user_entity_name%TYPE;
378: l_subj_whable ff_user_entities.user_entity_name%TYPE;
379: l_subj_nwhable ff_user_entities.user_entity_name%TYPE;
380: l_county_wheld ff_user_entities.user_entity_name%TYPE;
381: l_school_wheld ff_user_entities.user_entity_name%TYPE;
382:
383: TYPE RefCurType is REF CURSOR;
384: c_actions_no_selection RefCurType;

Line 381: l_school_wheld ff_user_entities.user_entity_name%TYPE;

377: l_city_wk_whld ff_user_entities.user_entity_name%TYPE;
378: l_subj_whable ff_user_entities.user_entity_name%TYPE;
379: l_subj_nwhable ff_user_entities.user_entity_name%TYPE;
380: l_county_wheld ff_user_entities.user_entity_name%TYPE;
381: l_school_wheld ff_user_entities.user_entity_name%TYPE;
382:
383: TYPE RefCurType is REF CURSOR;
384: c_actions_no_selection RefCurType;
385: c_actions_with_location RefCurType;

Line 1374: from ff_user_entities

1370:
1371: CURSOR c_state_ueid (p_user_entity_name varchar2) is
1372:
1373: select user_entity_id
1374: from ff_user_entities
1375: where user_entity_name = p_user_entity_name
1376: and legislation_code = 'US';
1377:
1378: l_sit_subj_whable ff_user_entities.user_entity_name%TYPE;

Line 1378: l_sit_subj_whable ff_user_entities.user_entity_name%TYPE;

1374: from ff_user_entities
1375: where user_entity_name = p_user_entity_name
1376: and legislation_code = 'US';
1377:
1378: l_sit_subj_whable ff_user_entities.user_entity_name%TYPE;
1379: l_sit_subj_nwhable ff_user_entities.user_entity_name%TYPE;
1380: l_sit_withheld ff_user_entities.user_entity_name%TYPE; /* 6809739 */
1381:
1382: /* when person is selected */

Line 1379: l_sit_subj_nwhable ff_user_entities.user_entity_name%TYPE;

1375: where user_entity_name = p_user_entity_name
1376: and legislation_code = 'US';
1377:
1378: l_sit_subj_whable ff_user_entities.user_entity_name%TYPE;
1379: l_sit_subj_nwhable ff_user_entities.user_entity_name%TYPE;
1380: l_sit_withheld ff_user_entities.user_entity_name%TYPE; /* 6809739 */
1381:
1382: /* when person is selected */
1383:

Line 1380: l_sit_withheld ff_user_entities.user_entity_name%TYPE; /* 6809739 */

1376: and legislation_code = 'US';
1377:
1378: l_sit_subj_whable ff_user_entities.user_entity_name%TYPE;
1379: l_sit_subj_nwhable ff_user_entities.user_entity_name%TYPE;
1380: l_sit_withheld ff_user_entities.user_entity_name%TYPE; /* 6809739 */
1381:
1382: /* when person is selected */
1383:
1384: /*CURSOR c_actions_with_person is --6712851