[Home] [Help]
982: ' AND exists ( select 1 from dual
983: where 1 =
984: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
985: from ff_archive_items fai,
986: ff_archive_item_contexts fic1,
987: ff_archive_item_contexts fic2
988: where fai.context1 = paa_arch.assignment_action_id
989: and fai.user_entity_id in (' || l_subj_whable || ',
990: ' || l_subj_nwhable || ')
983: where 1 =
984: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
985: from ff_archive_items fai,
986: ff_archive_item_contexts fic1,
987: ff_archive_item_contexts fic2
988: where fai.context1 = paa_arch.assignment_action_id
989: and fai.user_entity_id in (' || l_subj_whable || ',
990: ' || l_subj_nwhable || ')
991: and fai.archive_item_id = fic1.archive_item_id
1014: ' AND exists ( select 1 from dual
1015: where 1 =
1016: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1017: from ff_archive_items fai,
1018: ff_archive_item_contexts fic1,
1019: ff_archive_item_contexts fic2
1020: where fai.context1 = paa_arch.assignment_action_id
1021: and fai.user_entity_id in (' || l_county_wheld || ')
1022: and fai.archive_item_id = fic1.archive_item_id
1015: where 1 =
1016: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1017: from ff_archive_items fai,
1018: ff_archive_item_contexts fic1,
1019: ff_archive_item_contexts fic2
1020: where fai.context1 = paa_arch.assignment_action_id
1021: and fai.user_entity_id in (' || l_county_wheld || ')
1022: and fai.archive_item_id = fic1.archive_item_id
1023: and fic1.context_id = ' || l_tuid_context || '
1038: ' AND exists ( select 1 from dual
1039: where 1 =
1040: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1041: from ff_archive_items fai,
1042: ff_archive_item_contexts fic1,
1043: ff_archive_item_contexts fic2
1044: where fai.context1 = paa_arch.assignment_action_id
1045: and fai.user_entity_id in (' || l_subj_whable || ',
1046: ' || l_subj_nwhable || ')
1039: where 1 =
1040: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1041: from ff_archive_items fai,
1042: ff_archive_item_contexts fic1,
1043: ff_archive_item_contexts fic2
1044: where fai.context1 = paa_arch.assignment_action_id
1045: and fai.user_entity_id in (' || l_subj_whable || ',
1046: ' || l_subj_nwhable || ')
1047: and fai.archive_item_id = fic1.archive_item_id
1073: ' AND exists ( select 1 from dual
1074: where 1 =
1075: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1076: from ff_archive_items fai,
1077: ff_archive_item_contexts fic1,
1078: ff_archive_item_contexts fic2
1079: where fai.context1 = paa_arch.assignment_action_id
1080: and fai.user_entity_id in (' || l_city_wk_whld || ')
1081: and fai.archive_item_id = fic1.archive_item_id
1074: where 1 =
1075: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1076: from ff_archive_items fai,
1077: ff_archive_item_contexts fic1,
1078: ff_archive_item_contexts fic2
1079: where fai.context1 = paa_arch.assignment_action_id
1080: and fai.user_entity_id in (' || l_city_wk_whld || ')
1081: and fai.archive_item_id = fic1.archive_item_id
1082: and fic1.context_id = ' || l_tuid_context || '
1097: ' AND exists ( select 1 from dual
1098: where 1 =
1099: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1100: from ff_archive_items fai,
1101: ff_archive_item_contexts fic1,
1102: ff_archive_item_contexts fic2
1103: where fai.context1 = paa_arch.assignment_action_id
1104: and fai.user_entity_id in (' || l_subj_whable || ',
1105: ' || l_subj_nwhable || ')
1098: where 1 =
1099: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1100: from ff_archive_items fai,
1101: ff_archive_item_contexts fic1,
1102: ff_archive_item_contexts fic2
1103: where fai.context1 = paa_arch.assignment_action_id
1104: and fai.user_entity_id in (' || l_subj_whable || ',
1105: ' || l_subj_nwhable || ')
1106: and fai.archive_item_id = fic1.archive_item_id
1128: ' AND exists ( select 1 from dual
1129: where 1 =
1130: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1131: from ff_archive_items fai,
1132: ff_archive_item_contexts fic1,
1133: ff_archive_item_contexts fic2
1134: where fai.context1 = paa_arch.assignment_action_id
1135: and fai.user_entity_id in (' || l_school_wheld || ')
1136: and fai.archive_item_id = fic1.archive_item_id
1129: where 1 =
1130: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1131: from ff_archive_items fai,
1132: ff_archive_item_contexts fic1,
1133: ff_archive_item_contexts fic2
1134: where fai.context1 = paa_arch.assignment_action_id
1135: and fai.user_entity_id in (' || l_school_wheld || ')
1136: and fai.archive_item_id = fic1.archive_item_id
1137: and fic1.context_id = ' || l_tuid_context || '
1152: ' AND exists ( select 1 from dual
1153: where 1 =
1154: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1155: from ff_archive_items fai,
1156: ff_archive_item_contexts fic1,
1157: ff_archive_item_contexts fic2
1158: where fai.context1 = paa_arch.assignment_action_id
1159: and fai.user_entity_id in (' || l_subj_whable || ',
1160: ' || l_subj_nwhable || ')
1153: where 1 =
1154: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1155: from ff_archive_items fai,
1156: ff_archive_item_contexts fic1,
1157: ff_archive_item_contexts fic2
1158: where fai.context1 = paa_arch.assignment_action_id
1159: and fai.user_entity_id in (' || l_subj_whable || ',
1160: ' || l_subj_nwhable || ')
1161: and fai.archive_item_id = fic1.archive_item_id
1408: AND exists ( select 1 from dual
1409: where 1 =
1410: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1411: from ff_archive_items fai,
1412: ff_archive_item_contexts fic1,
1413: ff_archive_item_contexts fic2
1414: where fai.context1 = paa_arch.assignment_action_id
1415: and fai.user_entity_id in
1416: ( l_sit_subj_whable,
1409: where 1 =
1410: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1411: from ff_archive_items fai,
1412: ff_archive_item_contexts fic1,
1413: ff_archive_item_contexts fic2
1414: where fai.context1 = paa_arch.assignment_action_id
1415: and fai.user_entity_id in
1416: ( l_sit_subj_whable,
1417: l_sit_subj_nwhable,
1527: AND exists ( select 1 from dual
1528: where 1 =
1529: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1530: from ff_archive_items fai,
1531: ff_archive_item_contexts fic1,
1532: ff_archive_item_contexts fic2
1533: where fai.context1 = paa_arch.assignment_action_id
1534: and fai.user_entity_id in
1535: ( ' || l_sit_subj_whable || ',
1528: where 1 =
1529: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1530: from ff_archive_items fai,
1531: ff_archive_item_contexts fic1,
1532: ff_archive_item_contexts fic2
1533: where fai.context1 = paa_arch.assignment_action_id
1534: and fai.user_entity_id in
1535: ( ' || l_sit_subj_whable || ',
1536: ' || l_sit_subj_nwhable || ',
1564: AND exists ( select 1 from dual
1565: where 1 =
1566: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1567: from ff_archive_items fai,
1568: ff_archive_item_contexts fic1,
1569: ff_archive_item_contexts fic2
1570: where fai.context1 = paa_arch.assignment_action_id
1571: and fai.user_entity_id in
1572: ( ' || l_sit_subj_whable || ',
1565: where 1 =
1566: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1567: from ff_archive_items fai,
1568: ff_archive_item_contexts fic1,
1569: ff_archive_item_contexts fic2
1570: where fai.context1 = paa_arch.assignment_action_id
1571: and fai.user_entity_id in
1572: ( ' || l_sit_subj_whable || ',
1573: ' || l_sit_subj_nwhable || ',
1655: AND exists ( select 1 from dual
1656: where 1 =
1657: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1658: from ff_archive_items fai,
1659: ff_archive_item_contexts fic1,
1660: ff_archive_item_contexts fic2
1661: where fai.context1 = paa_arch.assignment_action_id
1662: and fai.user_entity_id in
1663: ( ' || l_sit_subj_whable || ',
1656: where 1 =
1657: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1658: from ff_archive_items fai,
1659: ff_archive_item_contexts fic1,
1660: ff_archive_item_contexts fic2
1661: where fai.context1 = paa_arch.assignment_action_id
1662: and fai.user_entity_id in
1663: ( ' || l_sit_subj_whable || ',
1664: ' || l_sit_subj_nwhable || ',
1697: AND exists ( select 1 from dual
1698: where 1 =
1699: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1700: from ff_archive_items fai,
1701: ff_archive_item_contexts fic1,
1702: ff_archive_item_contexts fic2
1703: where fai.context1 = paa_arch.assignment_action_id
1704: and fai.user_entity_id in
1705: ( ' || l_sit_subj_whable || ',
1698: where 1 =
1699: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1700: from ff_archive_items fai,
1701: ff_archive_item_contexts fic1,
1702: ff_archive_item_contexts fic2
1703: where fai.context1 = paa_arch.assignment_action_id
1704: and fai.user_entity_id in
1705: ( ' || l_sit_subj_whable || ',
1706: ' || l_sit_subj_nwhable || ',
1791: AND exists ( select 1 from dual
1792: where 1 =
1793: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1794: from ff_archive_items fai,
1795: ff_archive_item_contexts fic1,
1796: ff_archive_item_contexts fic2
1797: where fai.context1 = paa_arch.assignment_action_id
1798: and fai.user_entity_id in
1799: ( ' || l_sit_subj_whable || ',
1792: where 1 =
1793: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1794: from ff_archive_items fai,
1795: ff_archive_item_contexts fic1,
1796: ff_archive_item_contexts fic2
1797: where fai.context1 = paa_arch.assignment_action_id
1798: and fai.user_entity_id in
1799: ( ' || l_sit_subj_whable || ',
1800: ' || l_sit_subj_nwhable || ',
1833: AND exists ( select 1 from dual
1834: where 1 =
1835: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1836: from ff_archive_items fai,
1837: ff_archive_item_contexts fic1,
1838: ff_archive_item_contexts fic2
1839: where fai.context1 = paa_arch.assignment_action_id
1840: and fai.user_entity_id in
1841: ( ' || l_sit_subj_whable || ',
1834: where 1 =
1835: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1836: from ff_archive_items fai,
1837: ff_archive_item_contexts fic1,
1838: ff_archive_item_contexts fic2
1839: where fai.context1 = paa_arch.assignment_action_id
1840: and fai.user_entity_id in
1841: ( ' || l_sit_subj_whable || ',
1842: ' || l_sit_subj_nwhable || ',
1967: AND exists ( select 1 from dual
1968: where 1 =
1969: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1970: from ff_archive_items fai,
1971: ff_archive_item_contexts fic1,
1972: ff_archive_item_contexts fic2
1973: where fai.context1 = paa_arch.assignment_action_id
1974: and fai.user_entity_id in
1975: ( ' || l_sit_subj_whable || ',
1968: where 1 =
1969: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1970: from ff_archive_items fai,
1971: ff_archive_item_contexts fic1,
1972: ff_archive_item_contexts fic2
1973: where fai.context1 = paa_arch.assignment_action_id
1974: and fai.user_entity_id in
1975: ( ' || l_sit_subj_whable || ',
1976: ' || l_sit_subj_nwhable || ',
2007: AND exists ( select 1 from dual
2008: where 1 =
2009: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
2010: from ff_archive_items fai,
2011: ff_archive_item_contexts fic1,
2012: ff_archive_item_contexts fic2
2013: where fai.context1 = paa_arch.assignment_action_id
2014: and fai.user_entity_id in
2015: ( ' || l_sit_subj_whable || ',
2008: where 1 =
2009: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
2010: from ff_archive_items fai,
2011: ff_archive_item_contexts fic1,
2012: ff_archive_item_contexts fic2
2013: where fai.context1 = paa_arch.assignment_action_id
2014: and fai.user_entity_id in
2015: ( ' || l_sit_subj_whable || ',
2016: ' || l_sit_subj_nwhable || ',