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_CONTEXTS

Line 356: select context_id from ff_contexts

352: AND paf.assignment_type = 'E'
353: AND paf.person_id between stperson and endperson;
354: */
355: CURSOR c_state_context (p_context_name varchar2) is
356: select context_id from ff_contexts
357: where context_name = p_context_name;
358:
359: l_tuid_context ff_contexts.context_id%TYPE;
360: l_juri_context ff_contexts.context_id%TYPE;

Line 359: l_tuid_context ff_contexts.context_id%TYPE;

355: CURSOR c_state_context (p_context_name varchar2) is
356: select context_id from ff_contexts
357: where context_name = p_context_name;
358:
359: l_tuid_context ff_contexts.context_id%TYPE;
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

Line 360: l_juri_context ff_contexts.context_id%TYPE;

356: select context_id from ff_contexts
357: where context_name = p_context_name;
358:
359: l_tuid_context ff_contexts.context_id%TYPE;
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

Line 1371: select context_id from ff_contexts

1367: /* 4152323 variables definitions end */
1368:
1369: CURSOR c_state_context (p_context_name varchar2) is
1370:
1371: select context_id from ff_contexts
1372: where context_name = p_context_name;
1373:
1374: l_tuid_context ff_contexts.context_id%TYPE;
1375: l_juri_context ff_contexts.context_id%TYPE;

Line 1374: l_tuid_context ff_contexts.context_id%TYPE;

1370:
1371: select context_id from ff_contexts
1372: where context_name = p_context_name;
1373:
1374: l_tuid_context ff_contexts.context_id%TYPE;
1375: l_juri_context ff_contexts.context_id%TYPE;
1376:
1377: CURSOR c_state_ueid (p_user_entity_name varchar2) is
1378:

Line 1375: l_juri_context ff_contexts.context_id%TYPE;

1371: select context_id from ff_contexts
1372: where context_name = p_context_name;
1373:
1374: l_tuid_context ff_contexts.context_id%TYPE;
1375: l_juri_context ff_contexts.context_id%TYPE;
1376:
1377: CURSOR c_state_ueid (p_user_entity_name varchar2) is
1378:
1379: select user_entity_id