APPS.PAY_US_MMREF_REPORTING1 dependencies on FF_DATABASE_ITEMS

Line 40: FROM ff_database_items DI,

36: ) RETURN NUMBER IS
37: -- Get the defined_balance_id for the specified balance DB item.
38: CURSOR csr_defined_balance IS
39: SELECT TO_NUMBER(UE.creator_id)
40: FROM ff_database_items DI,
41: ff_user_entities UE
42: WHERE DI.user_name = p_db_item_name
43: AND UE.user_entity_id = DI.user_entity_id
44: AND UE.creator_type = 'B'

Line 294: FROM ff_database_items fdi

290: /* cursor to get user_entity_id */
291: CURSOR c_user_entity_id_of_bal
292: IS
293: SELECT user_entity_id
294: FROM ff_database_items fdi
295: WHERE user_name = 'A_SIT_SUBJ_WHABLE_PER_JD_GRE_YTD' ;
296:
297:
298: /* cursor to get_context_of_tax_unit_id */

Line 321: ff_database_items fdi

317: ff_archive_item_contexts con2,
318: ff_contexts fc3,
319: ff_contexts fc2,
320: ff_archive_items target,
321: ff_database_items fdi
322: WHERE target.context1 = to_char(cp_payroll_action_id)
323: /* context of payroll_action_id */
324: AND fdi.user_name = 'A_FIPS_CODE_JD'
325: AND target.user_entity_id = fdi.user_entity_id

Line 854: ff_database_items fdi,

850: SELECT DISTINCT
851: to_number(paa.serial_number)
852: FROM ff_archive_item_contexts faic,
853: ff_archive_items fai,
854: ff_database_items fdi,
855: pay_assignment_actions paa,
856: pay_payroll_actions ppa,
857: per_all_assignments_f paf,
858: pay_payroll_actions ppa1

Line 942: ff_database_items fdi,

938: paa.tax_unit_id,
939: faic.context , 2),0)
940: FROM ff_archive_item_contexts faic,
941: ff_archive_items fai,
942: ff_database_items fdi,
943: pay_assignment_actions paa,
944: pay_payroll_actions ppa,
945: per_all_assignments_f paf,
946: pay_payroll_actions ppa1

Line 1006: ff_database_items fdi,

1002: paa.tax_unit_id,
1003: faic.context , 2),0)
1004: FROM ff_archive_item_contexts faic,
1005: ff_archive_items fai,
1006: ff_database_items fdi,
1007: pay_assignment_actions paa,
1008: pay_payroll_actions ppa,
1009: per_all_assignments_f paf,
1010: pay_payroll_actions ppa1

Line 1086: ff_database_items fdi

1082: select to_number(fai.value) value
1083: from ff_archive_item_contexts faic,
1084: ff_archive_items fai,
1085: ff_contexts fc,
1086: ff_database_items fdi
1087: where fdi.user_name = p_user_name
1088: and fc.context_name = 'TAX_UNIT_ID'
1089: and fai.context1 = to_char(p_assignment_action_id)
1090: and fai.user_entity_id = fdi.user_entity_id

Line 1102: ff_database_items fdi

1098: select to_number(fai.value) value
1099: from ff_archive_item_contexts faic,
1100: ff_archive_items fai,
1101: ff_contexts fc,
1102: ff_database_items fdi
1103: where fdi.user_name IN ('A_REGULAR_EARNINGS_PER_GRE_YTD',
1104: 'A_SUPPLEMENTAL_EARNINGS_FOR_FIT_SUBJECT_TO_TAX_PER_GRE_YTD',
1105: 'A_SUPPLEMENTAL_EARNINGS_FOR_NWFIT_SUBJECT_TO_TAX_PER_GRE_YTD',
1106: 'A_PRE_TAX_DEDUCTIONS_FOR_FIT_SUBJECT_TO_TAX_PER_GRE_YTD',

Line 1371: FROM ff_database_items

1367:
1368: CURSOR c_get_user_entity_id
1369: IS
1370: SELECT user_entity_id
1371: FROM ff_database_items
1372: WHERE user_name in ( 'A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER',
1373: 'A_TAX_UNIT_NAME');
1374:
1375: CURSOR c_get_address_entity_id

Line 1378: FROM ff_database_items

1374:
1375: CURSOR c_get_address_entity_id
1376: IS
1377: SELECT user_entity_id
1378: FROM ff_database_items
1379: WHERE user_name = 'TAX_UNIT_ADDRESS_LINE_1';
1380:
1381:
1382:

Line 1551: ff_database_items fdi

1547: ff_archive_item_contexts con2,
1548: ff_contexts fc3,
1549: ff_contexts fc2,
1550: ff_archive_items target,
1551: ff_database_items fdi
1552: WHERE target.context1 = to_char(cp_payroll_action_id)
1553: /* context of payroll_action_id */
1554: and fdi.user_name = 'A_STATE_TAX_RULES_ORG_SIT_COMPANY_STATE_ID'
1555: and target.user_entity_id = fdi.user_entity_id