[Home] [Help]
153: ) RETURN NUMBER IS
154: -- Get the defined_balance_id for the specified balance DB item.
155: CURSOR csr_defined_balance IS
156: SELECT TO_NUMBER(UE.creator_id)
157: FROM ff_database_items DI,
158: ff_user_entities UE
159: WHERE DI.user_name = p_db_item_name
160: AND UE.user_entity_id = DI.user_entity_id
161: AND UE.creator_type = 'B'
407: /* cursor to get user_entity_id */
408: CURSOR c_user_entity_id_of_bal
409: IS
410: SELECT user_entity_id
411: FROM ff_database_items fdi
412: WHERE user_name = 'A_SIT_SUBJ_WHABLE_PER_JD_GRE_YTD' ;
413:
414:
415: /* cursor to get_context_of_tax_unit_id */
434: ff_archive_item_contexts con2,
435: ff_contexts fc3,
436: ff_contexts fc2,
437: ff_archive_items target,
438: ff_database_items fdi
439: WHERE target.context1 = to_char(cp_payroll_action_id)
440: /* context of payroll_action_id */
441: AND fdi.user_name = 'A_FIPS_CODE_JD'
442: AND target.user_entity_id = fdi.user_entity_id
975: p_sqlstr := 'SELECT DISTINCT '||
976: 'to_number(paa.serial_number) '||
977: 'FROM ff_archive_item_contexts faic, '||
978: 'ff_archive_items fai, '||
979: 'ff_database_items fdi, '||
980: 'pay_assignment_actions paa, '||
981: 'pay_payroll_actions ppa, '||
982: 'per_all_assignments_f paf, '||
983: 'pay_payroll_actions ppa1 '||
1006: 'exists (select ''x'' '||
1007: 'from ff_contexts fc1, '||
1008: 'ff_archive_items fai1, '||
1009: 'ff_archive_item_contexts faic1, '||
1010: 'ff_database_items fdi1 '||
1011: 'where fc1.context_name = ''JURISDICTION_CODE'' '||
1012: 'and fc1.context_id = faic1.context_id '||
1013: 'and fdi1.user_name = ''A_COUNTY_WITHHELD_PER_JD_GRE_YTD'' '||
1014: 'and fdi1.user_entity_id = fai1.user_entity_id '||
1043: p_sqlstr := 'SELECT DISTINCT '||
1044: 'to_number(paa.serial_number) '||
1045: 'FROM ff_archive_item_contexts faic, '||
1046: 'ff_archive_items fai, '||
1047: 'ff_database_items fdi, '||
1048: 'pay_assignment_actions paa, '||
1049: 'pay_payroll_actions ppa, '||
1050: 'per_all_assignments_f paf, '||
1051: 'pay_payroll_actions ppa1 '||
1074: 'exists (select ''x'' '||
1075: 'from ff_contexts fc1, '||
1076: 'ff_archive_items fai1, '||
1077: 'ff_archive_item_contexts faic1, '||
1078: 'ff_database_items fdi1 '||
1079: 'where fc1.context_name = ''JURISDICTION_CODE'' '||
1080: 'and fc1.context_id = faic1.context_id '||
1081: 'and fdi1.user_name = ''A_SCHOOL_WITHHELD_PER_JD_GRE_YTD'' '||
1082: 'and fdi1.user_entity_id = fai1.user_entity_id '||
1113: SELECT DISTINCT
1114: to_number(paa.serial_number)
1115: FROM ff_archive_item_contexts faic,
1116: ff_archive_items fai,
1117: ff_database_items fdi,
1118: pay_assignment_actions paa,
1119: pay_payroll_actions ppa,
1120: per_all_assignments_f paf,
1121: pay_payroll_actions ppa1
1201: paa.tax_unit_id,
1202: faic.context , 2),0)
1203: FROM ff_archive_item_contexts faic,
1204: ff_archive_items fai,
1205: ff_database_items fdi,
1206: pay_assignment_actions paa,
1207: pay_payroll_actions ppa,
1208: per_all_assignments_f paf,
1209: pay_payroll_actions ppa1
1271: paa.tax_unit_id,
1272: faic.context , 2),0)
1273: FROM ff_archive_item_contexts faic,
1274: ff_archive_items fai,
1275: ff_database_items fdi,
1276: pay_assignment_actions paa,
1277: pay_payroll_actions ppa,
1278: per_all_assignments_f paf,
1279: pay_payroll_actions ppa1,
1348: paa.tax_unit_id,
1349: faic.context , 2),0)
1350: FROM ff_archive_item_contexts faic,
1351: ff_archive_items fai,
1352: ff_database_items fdi,
1353: pay_assignment_actions paa,
1354: pay_payroll_actions ppa,
1355: per_all_assignments_f paf,
1356: pay_payroll_actions ppa1
1413: paa.tax_unit_id,
1414: faic.context , 2),0)
1415: FROM ff_archive_item_contexts faic,
1416: ff_archive_items fai,
1417: ff_database_items fdi,
1418: pay_assignment_actions paa,
1419: pay_payroll_actions ppa,
1420: per_all_assignments_f paf,
1421: pay_payroll_actions ppa1,
1486: paa.tax_unit_id,
1487: faic.context , 2),0)
1488: FROM ff_archive_item_contexts faic,
1489: ff_archive_items fai,
1490: ff_database_items fdi,
1491: pay_assignment_actions paa,
1492: pay_payroll_actions ppa,
1493: per_all_assignments_f paf,
1494: pay_payroll_actions ppa1
1525: exists (select 'x'
1526: from ff_contexts fc1,
1527: ff_archive_items fai1,
1528: ff_archive_item_contexts faic1,
1529: ff_database_items fdi1
1530: where fc1.context_name = 'JURISDICTION_CODE'
1531: and fc1.context_id = faic1.context_id
1532: and fdi1.user_name = 'A_COUNTY_WITHHELD_PER_JD_GRE_YTD'
1533: and fdi1.user_entity_id = fai1.user_entity_id
1561: paa.tax_unit_id,
1562: faic.context , 2),0)
1563: FROM ff_archive_item_contexts faic,
1564: ff_archive_items fai,
1565: ff_database_items fdi,
1566: pay_assignment_actions paa,
1567: pay_payroll_actions ppa,
1568: per_all_assignments_f paf,
1569: pay_payroll_actions ppa1,
1603: exists (select 'x'
1604: from ff_contexts fc1,
1605: ff_archive_items fai1,
1606: ff_archive_item_contexts faic1,
1607: ff_database_items fdi1
1608: where fc1.context_name = 'JURISDICTION_CODE'
1609: and fc1.context_id = faic1.context_id
1610: and fdi1.user_name = 'A_COUNTY_WITHHELD_PER_JD_GRE_YTD'
1611: and fdi1.user_entity_id = fai1.user_entity_id
1642: paa.tax_unit_id,
1643: faic.context , 2),0)
1644: FROM ff_archive_item_contexts faic,
1645: ff_archive_items fai,
1646: ff_database_items fdi,
1647: pay_assignment_actions paa,
1648: pay_payroll_actions ppa,
1649: per_all_assignments_f paf,
1650: pay_payroll_actions ppa1
1680: exists (select 'x'
1681: from ff_contexts fc1,
1682: ff_archive_items fai1,
1683: ff_archive_item_contexts faic1,
1684: ff_database_items fdi1
1685: where fc1.context_name = 'JURISDICTION_CODE'
1686: and fc1.context_id = faic1.context_id
1687: and fdi1.user_name = 'A_SCHOOL_WITHHELD_PER_JD_GRE_YTD'
1688: and fdi1.user_entity_id = fai1.user_entity_id
1716: paa.tax_unit_id,
1717: faic.context , 2),0)
1718: FROM ff_archive_item_contexts faic,
1719: ff_archive_items fai,
1720: ff_database_items fdi,
1721: pay_assignment_actions paa,
1722: pay_payroll_actions ppa,
1723: per_all_assignments_f paf,
1724: pay_payroll_actions ppa1,
1757: exists (select 'x'
1758: from ff_contexts fc1,
1759: ff_archive_items fai1,
1760: ff_archive_item_contexts faic1,
1761: ff_database_items fdi1
1762: where fc1.context_name = 'JURISDICTION_CODE'
1763: and fc1.context_id = faic1.context_id
1764: and fdi1.user_name = 'A_SCHOOL_WITHHELD_PER_JD_GRE_YTD'
1765: and fdi1.user_entity_id = fai1.user_entity_id
1854: select to_number(fai.value) value
1855: from ff_archive_item_contexts faic,
1856: ff_archive_items fai,
1857: ff_contexts fc,
1858: ff_database_items fdi
1859: where fdi.user_name = p_user_name
1860: and fc.context_name = 'TAX_UNIT_ID'
1861: and fai.context1 = to_char(p_assignment_action_id)
1862: and fai.user_entity_id = fdi.user_entity_id
1870: select to_number(fai.value) value
1871: from ff_archive_item_contexts faic,
1872: ff_archive_items fai,
1873: ff_contexts fc,
1874: ff_database_items fdi
1875: where fdi.user_name IN ('A_REGULAR_EARNINGS_PER_GRE_YTD',
1876: 'A_SUPPLEMENTAL_EARNINGS_FOR_FIT_SUBJECT_TO_TAX_PER_GRE_YTD',
1877: 'A_SUPPLEMENTAL_EARNINGS_FOR_NWFIT_SUBJECT_TO_TAX_PER_GRE_YTD',
1878: 'A_PRE_TAX_DEDUCTIONS_FOR_FIT_SUBJECT_TO_TAX_PER_GRE_YTD',
2347:
2348: CURSOR c_get_user_entity_id
2349: IS
2350: SELECT user_entity_id
2351: FROM ff_database_items
2352: WHERE user_name in ( 'A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER',
2353: 'A_TAX_UNIT_NAME');
2354:
2355: CURSOR c_get_address_entity_id
2354:
2355: CURSOR c_get_address_entity_id
2356: IS
2357: SELECT user_entity_id
2358: FROM ff_database_items
2359: WHERE user_name = 'TAX_UNIT_ADDRESS_LINE_1';
2360:
2361:
2362:
2527: ff_archive_item_contexts con2,
2528: ff_contexts fc3,
2529: ff_contexts fc2,
2530: ff_archive_items target,
2531: ff_database_items fdi
2532: WHERE target.context1 = to_char(cp_payroll_action_id)
2533: /* context of payroll_action_id */
2534: and fdi.user_name = 'A_STATE_TAX_RULES_ORG_SIT_COMPANY_STATE_ID'
2535: and target.user_entity_id = fdi.user_entity_id