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.

[Home] [Help]

APPS.HR_US_W2_MT dependencies on FF_USER_ENTITIES

Line 364: from ff_user_entities

360: l_juri_context ff_contexts.context_id%TYPE;
361:
362: CURSOR c_state_ueid (p_user_entity_name varchar2) is
363: select user_entity_id
364: from ff_user_entities
365: where user_entity_name = p_user_entity_name
366: and legislation_code = 'US';
367:
368: l_city_wk_whld ff_user_entities.user_entity_name%TYPE;

Line 368: l_city_wk_whld ff_user_entities.user_entity_name%TYPE;

364: from ff_user_entities
365: where user_entity_name = p_user_entity_name
366: and legislation_code = 'US';
367:
368: l_city_wk_whld ff_user_entities.user_entity_name%TYPE;
369: l_subj_whable ff_user_entities.user_entity_name%TYPE;
370: l_subj_nwhable ff_user_entities.user_entity_name%TYPE;
371: l_county_wheld ff_user_entities.user_entity_name%TYPE;
372: l_school_wheld ff_user_entities.user_entity_name%TYPE;

Line 369: l_subj_whable ff_user_entities.user_entity_name%TYPE;

365: where user_entity_name = p_user_entity_name
366: and legislation_code = 'US';
367:
368: l_city_wk_whld ff_user_entities.user_entity_name%TYPE;
369: l_subj_whable ff_user_entities.user_entity_name%TYPE;
370: l_subj_nwhable ff_user_entities.user_entity_name%TYPE;
371: l_county_wheld ff_user_entities.user_entity_name%TYPE;
372: l_school_wheld ff_user_entities.user_entity_name%TYPE;
373:

Line 370: l_subj_nwhable ff_user_entities.user_entity_name%TYPE;

366: and legislation_code = 'US';
367:
368: l_city_wk_whld ff_user_entities.user_entity_name%TYPE;
369: l_subj_whable ff_user_entities.user_entity_name%TYPE;
370: l_subj_nwhable ff_user_entities.user_entity_name%TYPE;
371: l_county_wheld ff_user_entities.user_entity_name%TYPE;
372: l_school_wheld ff_user_entities.user_entity_name%TYPE;
373:
374: TYPE RefCurType is REF CURSOR;

Line 371: l_county_wheld ff_user_entities.user_entity_name%TYPE;

367:
368: l_city_wk_whld ff_user_entities.user_entity_name%TYPE;
369: l_subj_whable ff_user_entities.user_entity_name%TYPE;
370: l_subj_nwhable ff_user_entities.user_entity_name%TYPE;
371: l_county_wheld ff_user_entities.user_entity_name%TYPE;
372: l_school_wheld ff_user_entities.user_entity_name%TYPE;
373:
374: TYPE RefCurType is REF CURSOR;
375: c_actions_no_selection RefCurType;

Line 372: l_school_wheld ff_user_entities.user_entity_name%TYPE;

368: l_city_wk_whld ff_user_entities.user_entity_name%TYPE;
369: l_subj_whable ff_user_entities.user_entity_name%TYPE;
370: l_subj_nwhable ff_user_entities.user_entity_name%TYPE;
371: l_county_wheld ff_user_entities.user_entity_name%TYPE;
372: l_school_wheld ff_user_entities.user_entity_name%TYPE;
373:
374: TYPE RefCurType is REF CURSOR;
375: c_actions_no_selection RefCurType;
376: c_actions_with_location RefCurType;

Line 1380: from ff_user_entities

1376:
1377: CURSOR c_state_ueid (p_user_entity_name varchar2) is
1378:
1379: select user_entity_id
1380: from ff_user_entities
1381: where user_entity_name = p_user_entity_name
1382: and legislation_code = 'US';
1383:
1384: l_sit_subj_whable ff_user_entities.user_entity_name%TYPE;

Line 1384: l_sit_subj_whable ff_user_entities.user_entity_name%TYPE;

1380: from ff_user_entities
1381: where user_entity_name = p_user_entity_name
1382: and legislation_code = 'US';
1383:
1384: l_sit_subj_whable ff_user_entities.user_entity_name%TYPE;
1385: l_sit_subj_nwhable ff_user_entities.user_entity_name%TYPE;
1386: l_sit_withheld ff_user_entities.user_entity_name%TYPE; /* 6809739 */
1387:
1388: /* when person is selected */

Line 1385: l_sit_subj_nwhable ff_user_entities.user_entity_name%TYPE;

1381: where user_entity_name = p_user_entity_name
1382: and legislation_code = 'US';
1383:
1384: l_sit_subj_whable ff_user_entities.user_entity_name%TYPE;
1385: l_sit_subj_nwhable ff_user_entities.user_entity_name%TYPE;
1386: l_sit_withheld ff_user_entities.user_entity_name%TYPE; /* 6809739 */
1387:
1388: /* when person is selected */
1389:

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

1382: and legislation_code = 'US';
1383:
1384: l_sit_subj_whable ff_user_entities.user_entity_name%TYPE;
1385: l_sit_subj_nwhable ff_user_entities.user_entity_name%TYPE;
1386: l_sit_withheld ff_user_entities.user_entity_name%TYPE; /* 6809739 */
1387:
1388: /* when person is selected */
1389:
1390: CURSOR c_actions_with_person is