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.PAY_GB_EOY_ARCHIVE dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 457: FROM ff_archive_item_contexts aic1,

453: -- use implicit cursors so that too_many_rows can easily be detected
454: IF p_context_value3 IS NOT NULL THEN
455: SELECT fai.VALUE
456: INTO l_arch_value
457: FROM ff_archive_item_contexts aic1,
458: ff_archive_item_contexts aic2,
459: ff_archive_item_contexts aic3,
460: ff_archive_items fai
461: WHERE fai.context1 = p_action_id

Line 458: ff_archive_item_contexts aic2,

454: IF p_context_value3 IS NOT NULL THEN
455: SELECT fai.VALUE
456: INTO l_arch_value
457: FROM ff_archive_item_contexts aic1,
458: ff_archive_item_contexts aic2,
459: ff_archive_item_contexts aic3,
460: ff_archive_items fai
461: WHERE fai.context1 = p_action_id
462: AND fai.user_entity_id = p_user_entity_id

Line 459: ff_archive_item_contexts aic3,

455: SELECT fai.VALUE
456: INTO l_arch_value
457: FROM ff_archive_item_contexts aic1,
458: ff_archive_item_contexts aic2,
459: ff_archive_item_contexts aic3,
460: ff_archive_items fai
461: WHERE fai.context1 = p_action_id
462: AND fai.user_entity_id = p_user_entity_id
463: AND aic1.archive_item_id = fai.archive_item_id

Line 476: ff_archive_item_contexts aic1,

472: ELSIF p_context_value2 IS NOT NULL THEN
473: SELECT fai.VALUE
474: INTO l_arch_value
475: FROM ff_archive_items fai,
476: ff_archive_item_contexts aic1,
477: ff_archive_item_contexts aic2
478: WHERE fai.context1 = p_action_id
479: AND fai.user_entity_id = p_user_entity_id
480: AND aic1.archive_item_id = fai.archive_item_id

Line 477: ff_archive_item_contexts aic2

473: SELECT fai.VALUE
474: INTO l_arch_value
475: FROM ff_archive_items fai,
476: ff_archive_item_contexts aic1,
477: ff_archive_item_contexts aic2
478: WHERE fai.context1 = p_action_id
479: AND fai.user_entity_id = p_user_entity_id
480: AND aic1.archive_item_id = fai.archive_item_id
481: AND aic1.sequence_no = 1

Line 489: FROM ff_archive_item_contexts aic1,

485: AND aic2.context = p_context_value2;
486: ELSIF p_context_value1 IS NOT NULL THEN
487: SELECT fai.VALUE
488: INTO l_arch_value
489: FROM ff_archive_item_contexts aic1,
490: ff_archive_items fai
491: WHERE fai.context1 = p_action_id
492: AND fai.user_entity_id = p_user_entity_id
493: AND aic1.archive_item_id = fai.archive_item_id

Line 640: ff_archive_item_contexts faic

636: cursor get_payroll_id(c_payroll_action_id number,
637: c_user_entity_id number) is
638: select to_number(faic.context) payroll_id
639: from ff_archive_items fai,
640: ff_archive_item_contexts faic
641: where fai.context1 = c_payroll_action_id
642: and fai.user_entity_id = c_user_entity_id
643: and fai.archive_item_id = faic.archive_item_id
644: and faic.sequence_no = 1;

Line 2318: FROM ff_archive_item_contexts aic, /* payrolls */

2314: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_ref_eid,
2315: aic.context) tax_ref,
2316: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_dist_ref_eid,
2317: aic.context) tax_dist
2318: FROM ff_archive_item_contexts aic, /* payrolls */
2319: ff_archive_items fai, /* X_START_YEAR */
2320: ff_user_entities fue,
2321: pay_payroll_actions pact
2322: WHERE pact.report_type = 'EOY'