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 998: ff_database_items fdi1 --database_items for City_withheld

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

Line 1081: ff_database_items fdi

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

Line 1277: FROM ff_database_items

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

Line 1284: FROM ff_database_items

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

Line 1451: ff_database_items fdi

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