[Home] [Help]
981: c_actions_with_state_sql := c_actions_with_state_sql ||
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 || ',
1013: c_actions_with_state_sql := c_actions_with_state_sql ||
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 || ')
1037: c_actions_with_state_sql := c_actions_with_state_sql ||
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 || ',
1072: c_actions_with_state_sql := c_actions_with_state_sql ||
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 || ')
1096: c_actions_with_state_sql := c_actions_with_state_sql ||
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 || ',
1127: c_actions_with_state_sql := c_actions_with_state_sql ||
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 || ')
1151: c_actions_with_state_sql := c_actions_with_state_sql ||
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 || ',
1407: AND paf.person_id between stperson and endperson
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
1526: AND paf.person_id = ppr.person_id
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
1563: and paf.person_id = to_number(paa_arch.serial_number)
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
1654: AND paf.person_id = ppr.person_id
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
1696: AND paf.person_id between ' || stperson || ' and ' || endperson || '
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
1790: AND paf.person_id = ppr.person_id
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
1832: AND paf.person_id between ' || stperson || ' and ' || endperson || '
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
1966: and upper(hasa.include_or_exclude) = ''I'')
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
2006: and upper(hasa.include_or_exclude) = ''I'')
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