APPS.PAY_US_MMREF_LOCAL dependencies on FF_DATABASE_ITEMS

Line 73: FROM ff_database_items DI,

69: ) RETURN NUMBER IS
70: -- Get the defined_balance_id for the specified balance DB item.
71: CURSOR csr_defined_balance IS
72: SELECT TO_NUMBER(UE.creator_id)
73: FROM ff_database_items DI,
74: ff_user_entities UE
75: WHERE DI.user_name = p_db_item_name
76: AND UE.user_entity_id = DI.user_entity_id
77: AND UE.creator_type = 'B'

Line 337: FROM ff_database_items fdi

333: /* cursor to get user_entity_id */
334: CURSOR c_user_entity_id_of_bal
335: IS
336: SELECT user_entity_id
337: FROM ff_database_items fdi
338: WHERE user_name = 'A_SIT_SUBJ_WHABLE_PER_JD_GRE_YTD' ;
339:
340:
341: /* cursor to get_context_of_tax_unit_id */

Line 364: ff_database_items fdi

360: ff_archive_item_contexts con2,
361: ff_contexts fc3,
362: ff_contexts fc2,
363: ff_archive_items target,
364: ff_database_items fdi
365: WHERE target.context1 = to_char(cp_payroll_action_id)
366: /* context of payroll_action_id */
367: AND fdi.user_name = 'A_FIPS_CODE_JD'
368: AND target.user_entity_id = fdi.user_entity_id

Line 902: ff_database_items fdi,

898: SELECT DISTINCT
899: to_number(paa.serial_number)
900: FROM ff_archive_item_contexts faic,
901: ff_archive_items fai,
902: ff_database_items fdi,
903: pay_assignment_actions paa,
904: pay_payroll_actions ppa,
905: per_all_assignments_f paf,
906: pay_payroll_actions ppa1

Line 999: ff_database_items fdi1 --database_items for City_withheld

995: pay_payroll_actions ppa1,
996: ff_contexts fc1 , --for city context
997: ff_archive_items fai1, -- city
998: ff_archive_item_contexts faic1, -- city_context
999: ff_database_items fdi1 --database_items for City_withheld
1000: --,pay_us_city_tax_info_f puctif
1001: WHERE
1002: ppa1.payroll_action_id = p_pactid
1003: and ppa.business_group_id+0 = ppa1.business_group_id

Line 1082: ff_database_items fdi

1078: select to_number(fai.value)
1079: from ff_archive_item_contexts faic,
1080: ff_archive_items fai,
1081: ff_contexts fc,
1082: ff_database_items fdi
1083: where fdi.user_name = 'A_GROSS_EARNINGS_PER_GRE_YTD'
1084: and fc.context_name = 'TAX_UNIT_ID'
1085: and fai.context1 = to_char(p_assignment_action_id)
1086: and fai.user_entity_id = fdi.user_entity_id

Line 1278: FROM ff_database_items

1274:
1275: CURSOR c_get_user_entity_id
1276: IS
1277: SELECT user_entity_id
1278: FROM ff_database_items
1279: WHERE user_name in ( 'A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER',
1280: 'A_TAX_UNIT_NAME');
1281:
1282: CURSOR c_get_address_entity_id

Line 1285: FROM ff_database_items

1281:
1282: CURSOR c_get_address_entity_id
1283: IS
1284: SELECT user_entity_id
1285: FROM ff_database_items
1286: WHERE user_name = 'TAX_UNIT_ADDRESS_LINE_1';
1287:
1288:
1289:

Line 1452: ff_database_items fdi

1448: ff_archive_item_contexts con2,
1449: ff_contexts fc3,
1450: ff_contexts fc2,
1451: ff_archive_items target,
1452: ff_database_items fdi
1453: WHERE target.context1 = to_char(cp_payroll_action_id)
1454: /* context of payroll_action_id */
1455: and fdi.user_name = 'A_STATE_TAX_RULES_ORG_SIT_COMPANY_STATE_ID'
1456: and target.user_entity_id = fdi.user_entity_id