[Home] [Help]
77: table instead of secure views.
78: 08-DEC-2002 ahanda 115.15 Changed view to use pay_us_state_w2_v
79: instead of pay_us_w2_state_v.
80: 19-MAY-2003 ahanda 115.16 2955696 Changed federal and state action_creation
81: cursor to add ff_contexts and get only
82: context of TAX_UNIT_ID.
83: 19-JUN-2003 ahanda 115.17 3013521 Changed federal and state action_creation
84: cursor to add to_char for tax_unit_id.
85: There will be no perf degradation as there
983: and paf.effective_start_date <= ppa.effective_date
984: and paf.effective_end_date >= ppa.start_date
985: and to_char(paa.tax_unit_id) in (
986: select ffaic2.context
987: from ff_contexts ffc,
988: ff_user_entities ffue,
989: ff_archive_items ffai,
990: ff_archive_items ffai2,
991: ff_archive_item_contexts ffaic,
989: ff_archive_items ffai,
990: ff_archive_items ffai2,
991: ff_archive_item_contexts ffaic,
992: ff_archive_item_contexts ffaic2,
993: ff_contexts ffc2
994: where ffai.context1 = cp_yrend_ppa_id
995: and ffue.user_entity_id = ffai.user_entity_id
996: and ffue.user_entity_name = 'A_US_1099R_TRANSMITTER_CODE'
997: and ffai.archive_item_id = ffaic.archive_item_id
1040: and paf.effective_end_date >= ppa.start_date
1041: and paf.business_group_id + 0 = ppa.business_group_id + 0
1042: and to_char(psv.tax_unit_id) in
1043: (select ffaic2.context
1044: from ff_contexts ffc,
1045: ff_user_entities ffue,
1046: ff_archive_items ffai,
1047: ff_archive_items ffai2,
1048: ff_archive_item_contexts ffaic,
1046: ff_archive_items ffai,
1047: ff_archive_items ffai2,
1048: ff_archive_item_contexts ffaic,
1049: ff_archive_item_contexts ffaic2,
1050: ff_contexts ffc2
1051: where ffai.context1 = cp_yrend_ppa_id
1052: and ffue.user_entity_id = ffai.user_entity_id
1053: and ffue.user_entity_name = 'A_US_1099R_TRANSMITTER_CODE'
1054: and ffai.archive_item_id = ffaic.archive_item_id