DBA Data[Home] [Help]

APPS.HR_US_W2_MT dependencies on FF_CONTEXTS

Line 365: select context_id from ff_contexts

361: AND paf.assignment_type = 'E'
362: AND paf.person_id between stperson and endperson;
363: */
364: CURSOR c_state_context (p_context_name varchar2) is
365: select context_id from ff_contexts
366: where context_name = p_context_name;
367:
368: l_tuid_context ff_contexts.context_id%TYPE;
369: l_juri_context ff_contexts.context_id%TYPE;

Line 368: l_tuid_context ff_contexts.context_id%TYPE;

364: CURSOR c_state_context (p_context_name varchar2) is
365: select context_id from ff_contexts
366: where context_name = p_context_name;
367:
368: l_tuid_context ff_contexts.context_id%TYPE;
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

Line 369: l_juri_context ff_contexts.context_id%TYPE;

365: select context_id from ff_contexts
366: where context_name = p_context_name;
367:
368: l_tuid_context ff_contexts.context_id%TYPE;
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

Line 1365: select context_id from ff_contexts

1361: /* 4152323 variables definitions end */
1362:
1363: CURSOR c_state_context (p_context_name varchar2) is
1364:
1365: select context_id from ff_contexts
1366: where context_name = p_context_name;
1367:
1368: l_tuid_context ff_contexts.context_id%TYPE;
1369: l_juri_context ff_contexts.context_id%TYPE;

Line 1368: l_tuid_context ff_contexts.context_id%TYPE;

1364:
1365: select context_id from ff_contexts
1366: where context_name = p_context_name;
1367:
1368: l_tuid_context ff_contexts.context_id%TYPE;
1369: l_juri_context ff_contexts.context_id%TYPE;
1370:
1371: CURSOR c_state_ueid (p_user_entity_name varchar2) is
1372:

Line 1369: l_juri_context ff_contexts.context_id%TYPE;

1365: select context_id from ff_contexts
1366: where context_name = p_context_name;
1367:
1368: l_tuid_context ff_contexts.context_id%TYPE;
1369: l_juri_context ff_contexts.context_id%TYPE;
1370:
1371: CURSOR c_state_ueid (p_user_entity_name varchar2) is
1372:
1373: select user_entity_id