[Home] [Help]
138: ) RETURN NUMBER IS
139: -- Get the defined_balance_id for the specified balance DB item.
140: CURSOR csr_defined_balance IS
141: SELECT TO_NUMBER(UE.creator_id)
142: FROM ff_database_items DI,
143: ff_user_entities UE
144: WHERE DI.user_name = p_db_item_name
145: AND UE.user_entity_id = DI.user_entity_id
146: AND UE.creator_type = 'B'
392: /* cursor to get user_entity_id */
393: CURSOR c_user_entity_id_of_bal
394: IS
395: SELECT user_entity_id
396: FROM ff_database_items fdi
397: WHERE user_name = 'A_SIT_SUBJ_WHABLE_PER_JD_GRE_YTD' ;
398:
399:
400: /* cursor to get_context_of_tax_unit_id */
419: ff_archive_item_contexts con2,
420: ff_contexts fc3,
421: ff_contexts fc2,
422: ff_archive_items target,
423: ff_database_items fdi
424: WHERE target.context1 = to_char(cp_payroll_action_id)
425: /* context of payroll_action_id */
426: AND fdi.user_name = 'A_FIPS_CODE_JD'
427: AND target.user_entity_id = fdi.user_entity_id
950: p_sqlstr := 'SELECT DISTINCT '||
951: 'to_number(paa.serial_number) '||
952: 'FROM ff_archive_item_contexts faic, '||
953: 'ff_archive_items fai, '||
954: 'ff_database_items fdi, '||
955: 'pay_assignment_actions paa, '||
956: 'pay_payroll_actions ppa, '||
957: 'per_all_assignments_f paf, '||
958: 'pay_payroll_actions ppa1 '||
981: 'exists (select ''x'' '||
982: 'from ff_contexts fc1, '||
983: 'ff_archive_items fai1, '||
984: 'ff_archive_item_contexts faic1, '||
985: 'ff_database_items fdi1 '||
986: 'where fc1.context_name = ''JURISDICTION_CODE'' '||
987: 'and fc1.context_id = faic1.context_id '||
988: 'and fdi1.user_name = ''A_COUNTY_WITHHELD_PER_JD_GRE_YTD'' '||
989: 'and fdi1.user_entity_id = fai1.user_entity_id '||
1018: p_sqlstr := 'SELECT DISTINCT '||
1019: 'to_number(paa.serial_number) '||
1020: 'FROM ff_archive_item_contexts faic, '||
1021: 'ff_archive_items fai, '||
1022: 'ff_database_items fdi, '||
1023: 'pay_assignment_actions paa, '||
1024: 'pay_payroll_actions ppa, '||
1025: 'per_all_assignments_f paf, '||
1026: 'pay_payroll_actions ppa1 '||
1049: 'exists (select ''x'' '||
1050: 'from ff_contexts fc1, '||
1051: 'ff_archive_items fai1, '||
1052: 'ff_archive_item_contexts faic1, '||
1053: 'ff_database_items fdi1 '||
1054: 'where fc1.context_name = ''JURISDICTION_CODE'' '||
1055: 'and fc1.context_id = faic1.context_id '||
1056: 'and fdi1.user_name = ''A_SCHOOL_WITHHELD_PER_JD_GRE_YTD'' '||
1057: 'and fdi1.user_entity_id = fai1.user_entity_id '||
1088: SELECT DISTINCT
1089: to_number(paa.serial_number)
1090: FROM ff_archive_item_contexts faic,
1091: ff_archive_items fai,
1092: ff_database_items fdi,
1093: pay_assignment_actions paa,
1094: pay_payroll_actions ppa,
1095: per_all_assignments_f paf,
1096: pay_payroll_actions ppa1
1176: paa.tax_unit_id,
1177: faic.context , 2),0)
1178: FROM ff_archive_item_contexts faic,
1179: ff_archive_items fai,
1180: ff_database_items fdi,
1181: pay_assignment_actions paa,
1182: pay_payroll_actions ppa,
1183: per_all_assignments_f paf,
1184: pay_payroll_actions ppa1
1248: paa.tax_unit_id,
1249: faic.context , 2),0)
1250: FROM ff_archive_item_contexts faic,
1251: ff_archive_items fai,
1252: ff_database_items fdi,
1253: pay_assignment_actions paa,
1254: pay_payroll_actions ppa,
1255: per_all_assignments_f paf,
1256: pay_payroll_actions ppa1
1319: paa.tax_unit_id,
1320: faic.context , 2),0)
1321: FROM ff_archive_item_contexts faic,
1322: ff_archive_items fai,
1323: ff_database_items fdi,
1324: pay_assignment_actions paa,
1325: pay_payroll_actions ppa,
1326: per_all_assignments_f paf,
1327: pay_payroll_actions ppa1
1358: exists (select 'x'
1359: from ff_contexts fc1,
1360: ff_archive_items fai1,
1361: ff_archive_item_contexts faic1,
1362: ff_database_items fdi1
1363: where fc1.context_name = 'JURISDICTION_CODE'
1364: and fc1.context_id = faic1.context_id
1365: and fdi1.user_name = 'A_COUNTY_WITHHELD_PER_JD_GRE_YTD'
1366: and fdi1.user_entity_id = fai1.user_entity_id
1397: paa.tax_unit_id,
1398: faic.context , 2),0)
1399: FROM ff_archive_item_contexts faic,
1400: ff_archive_items fai,
1401: ff_database_items fdi,
1402: pay_assignment_actions paa,
1403: pay_payroll_actions ppa,
1404: per_all_assignments_f paf,
1405: pay_payroll_actions ppa1
1435: exists (select 'x'
1436: from ff_contexts fc1,
1437: ff_archive_items fai1,
1438: ff_archive_item_contexts faic1,
1439: ff_database_items fdi1
1440: where fc1.context_name = 'JURISDICTION_CODE'
1441: and fc1.context_id = faic1.context_id
1442: and fdi1.user_name = 'A_SCHOOL_WITHHELD_PER_JD_GRE_YTD'
1443: and fdi1.user_entity_id = fai1.user_entity_id
1496: select to_number(fai.value) value
1497: from ff_archive_item_contexts faic,
1498: ff_archive_items fai,
1499: ff_contexts fc,
1500: ff_database_items fdi
1501: where fdi.user_name = p_user_name
1502: and fc.context_name = 'TAX_UNIT_ID'
1503: and fai.context1 = to_char(p_assignment_action_id)
1504: and fai.user_entity_id = fdi.user_entity_id
1512: select to_number(fai.value) value
1513: from ff_archive_item_contexts faic,
1514: ff_archive_items fai,
1515: ff_contexts fc,
1516: ff_database_items fdi
1517: where fdi.user_name IN ('A_REGULAR_EARNINGS_PER_GRE_YTD',
1518: 'A_SUPPLEMENTAL_EARNINGS_FOR_FIT_SUBJECT_TO_TAX_PER_GRE_YTD',
1519: 'A_SUPPLEMENTAL_EARNINGS_FOR_NWFIT_SUBJECT_TO_TAX_PER_GRE_YTD',
1520: 'A_PRE_TAX_DEDUCTIONS_FOR_FIT_SUBJECT_TO_TAX_PER_GRE_YTD',
1855:
1856: CURSOR c_get_user_entity_id
1857: IS
1858: SELECT user_entity_id
1859: FROM ff_database_items
1860: WHERE user_name in ( 'A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER',
1861: 'A_TAX_UNIT_NAME');
1862:
1863: CURSOR c_get_address_entity_id
1862:
1863: CURSOR c_get_address_entity_id
1864: IS
1865: SELECT user_entity_id
1866: FROM ff_database_items
1867: WHERE user_name = 'TAX_UNIT_ADDRESS_LINE_1';
1868:
1869:
1870:
2035: ff_archive_item_contexts con2,
2036: ff_contexts fc3,
2037: ff_contexts fc2,
2038: ff_archive_items target,
2039: ff_database_items fdi
2040: WHERE target.context1 = to_char(cp_payroll_action_id)
2041: /* context of payroll_action_id */
2042: and fdi.user_name = 'A_STATE_TAX_RULES_ORG_SIT_COMPANY_STATE_ID'
2043: and target.user_entity_id = fdi.user_entity_id