[Home] [Help]
597: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
598: FROM pay_za_irp5_bal_codes irp5,
599: ff_archive_items arc,
600: ff_database_items dbi,
601: ff_archive_item_contexts faic2,
602: ff_contexts ffc2
603: WHERE irp5.code IN (3608, 3614, 3707, 3718, 3901, 3902, 3903, 3904, 3905, 3906, 3907, 3909, 3915, 3920)
604: AND irp5.balance_sequence = 3
605: AND irp5.user_name = dbi.user_name
620: , irp5.code code
621: from pay_za_irp5_bal_codes irp5,
622: ff_archive_items arc,
623: ff_database_items dbi,
624: ff_archive_item_contexts faic2,
625: ff_contexts ffc2
626: where arc.context1 in (select ch.assignment_action_id
627: from pay_assignment_actions main
628: , pay_assignment_actions ch
657: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
658: FROM pay_za_irp5_bal_codes irp5,
659: ff_archive_items arc,
660: ff_database_items dbi,
661: ff_archive_item_contexts faic2,
662: ff_contexts ffc2
663: WHERE irp5.code IN (4001, 4002, 4003, 4004, 4006, 4007)
664: AND irp5.balance_sequence = 1
665: AND irp5.user_name = dbi.user_name
924: faic2.CONTEXT Tax_Directive_Number
925: FROM ff_archive_items arc,
926: ff_database_items dbi,
927: pay_za_irp5_bal_codes irp5,
928: ff_archive_item_contexts faic2,
929: ff_contexts ffc2
930: WHERE arc.user_entity_id = dbi.user_entity_id
931: and irp5.user_name = dbi.user_name
932: and arc.context1 in (select ch.assignment_action_id
948: faic2.CONTEXT Tax_Directive_Number
949: FROM ff_archive_items arc,
950: ff_database_items dbi,
951: pay_za_irp5_bal_codes irp5,
952: ff_archive_item_contexts faic2,
953: ff_contexts ffc2
954: WHERE arc.user_entity_id = dbi.user_entity_id
955: and irp5.user_name = dbi.user_name
956: and arc.context1 in (select ch.assignment_action_id