APPS.PAY_ZA_EOY_VAL dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 440: ff_archive_item_contexts faic2,

436: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
437: FROM pay_za_irp5_bal_codes irp5,
438: ff_archive_items arc,
439: ff_database_items dbi,
440: ff_archive_item_contexts faic2,
441: ff_contexts ffc2
442: WHERE irp5.code IN (3608, 3614, 3707, 3718, 3901, 3902, 3903, 3904, 3905, 3906, 3907, 3908, 3909, 3915)
443: AND irp5.balance_sequence = 3
444: AND irp5.user_name = dbi.user_name

Line 463: ff_archive_item_contexts faic2,

459: , irp5.code code
460: from pay_za_irp5_bal_codes irp5,
461: ff_archive_items arc,
462: ff_database_items dbi,
463: ff_archive_item_contexts faic2,
464: ff_contexts ffc2
465: where arc.context1 in (select ch.assignment_action_id
466: from pay_assignment_actions main
467: , pay_assignment_actions ch

Line 501: ff_archive_item_contexts faic2,

497: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
498: FROM pay_za_irp5_bal_codes irp5,
499: ff_archive_items arc,
500: ff_database_items dbi,
501: ff_archive_item_contexts faic2,
502: ff_contexts ffc2
503: WHERE irp5.code IN (4001, 4002, 4003, 4004, 4006, 4007)
504: AND irp5.balance_sequence = 1
505: AND irp5.user_name = dbi.user_name