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 433: FROM ff_archive_item_contexts aic1,

429: -- use implicit cursors so that too_many_rows can easily be detected
430: IF p_context_value3 IS NOT NULL THEN
431: SELECT fai.VALUE
432: INTO l_arch_value
433: FROM ff_archive_item_contexts aic1,
434: ff_archive_item_contexts aic2,
435: ff_archive_item_contexts aic3,
436: ff_archive_items fai
437: WHERE fai.context1 = p_action_id

Line 434: ff_archive_item_contexts aic2,

430: IF p_context_value3 IS NOT NULL THEN
431: SELECT fai.VALUE
432: INTO l_arch_value
433: FROM ff_archive_item_contexts aic1,
434: ff_archive_item_contexts aic2,
435: ff_archive_item_contexts aic3,
436: ff_archive_items fai
437: WHERE fai.context1 = p_action_id
438: AND fai.user_entity_id = p_user_entity_id

Line 435: ff_archive_item_contexts aic3,

431: SELECT fai.VALUE
432: INTO l_arch_value
433: FROM ff_archive_item_contexts aic1,
434: ff_archive_item_contexts aic2,
435: ff_archive_item_contexts aic3,
436: ff_archive_items fai
437: WHERE fai.context1 = p_action_id
438: AND fai.user_entity_id = p_user_entity_id
439: AND aic1.archive_item_id = fai.archive_item_id

Line 452: ff_archive_item_contexts aic1,

448: ELSIF p_context_value2 IS NOT NULL THEN
449: SELECT fai.VALUE
450: INTO l_arch_value
451: FROM ff_archive_items fai,
452: ff_archive_item_contexts aic1,
453: ff_archive_item_contexts aic2
454: WHERE fai.context1 = p_action_id
455: AND fai.user_entity_id = p_user_entity_id
456: AND aic1.archive_item_id = fai.archive_item_id

Line 453: ff_archive_item_contexts aic2

449: SELECT fai.VALUE
450: INTO l_arch_value
451: FROM ff_archive_items fai,
452: ff_archive_item_contexts aic1,
453: ff_archive_item_contexts aic2
454: WHERE fai.context1 = p_action_id
455: AND fai.user_entity_id = p_user_entity_id
456: AND aic1.archive_item_id = fai.archive_item_id
457: AND aic1.sequence_no = 1

Line 465: FROM ff_archive_item_contexts aic1,

461: AND aic2.context = p_context_value2;
462: ELSIF p_context_value1 IS NOT NULL THEN
463: SELECT fai.VALUE
464: INTO l_arch_value
465: FROM ff_archive_item_contexts aic1,
466: ff_archive_items fai
467: WHERE fai.context1 = p_action_id
468: AND fai.user_entity_id = p_user_entity_id
469: AND aic1.archive_item_id = fai.archive_item_id

Line 616: ff_archive_item_contexts faic

612: cursor get_payroll_id(c_payroll_action_id number,
613: c_user_entity_id number) is
614: select to_number(faic.context) payroll_id
615: from ff_archive_items fai,
616: ff_archive_item_contexts faic
617: where fai.context1 = c_payroll_action_id
618: and fai.user_entity_id = c_user_entity_id
619: and fai.archive_item_id = faic.archive_item_id
620: and faic.sequence_no = 1;

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

2265: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_ref_eid,
2266: aic.context) tax_ref,
2267: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_dist_ref_eid,
2268: aic.context) tax_dist
2269: FROM ff_archive_item_contexts aic, /* payrolls */
2270: ff_archive_items fai, /* X_START_YEAR */
2271: ff_user_entities fue,
2272: pay_payroll_actions pact
2273: WHERE pact.report_type = 'EOY'