DBA Data[Home] [Help]

APPS.HR_US_W2_REP dependencies on FF_CONTEXTS

Line 251: from ff_contexts

247: IS
248: l_context_id number := 0;
249: BEGIN
250: select context_id into l_context_id
251: from ff_contexts
252: where context_name = w2_context_name;
253:
254: return (l_context_id);
255:

Line 1224: ff_contexts fc,

1220:
1221: CURSOR c_tax_unit_item IS
1222: select fai.value
1223: from ff_archive_item_contexts faic,
1224: ff_contexts fc,
1225: ff_archive_items fai,
1226: ff_database_items fdi
1227: where fdi.user_name = w2_tax_unit_item
1228: and fdi.user_entity_id = fai.user_entity_id

Line 1347: ff_contexts fc2,

1343: fai.value
1344: from
1345: ff_archive_item_contexts faic2,
1346: ff_archive_item_contexts faic1,
1347: ff_contexts fc2,
1348: ff_contexts fc1,
1349: ff_archive_items fai,
1350: ff_database_items fdi
1351: where fdi.user_name = w2_state_item

Line 1348: ff_contexts fc1,

1344: from
1345: ff_archive_item_contexts faic2,
1346: ff_archive_item_contexts faic1,
1347: ff_contexts fc2,
1348: ff_contexts fc1,
1349: ff_archive_items fai,
1350: ff_database_items fdi
1351: where fdi.user_name = w2_state_item
1352: and fdi.user_entity_id = fai.user_entity_id