DBA Data[Home] [Help]

APPS.PAY_US_MMREF_LOCAL_XML dependencies on FF_DATABASE_ITEMS

Line 75: FROM ff_database_items DI,

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

Line 277: ff_database_items fdi,

273: SELECT DISTINCT
274: to_number(paa.serial_number)
275: FROM ff_archive_item_contexts faic,
276: ff_archive_items fai,
277: ff_database_items fdi,
278: pay_assignment_actions paa,
279: pay_payroll_actions ppa,
280: per_all_assignments_f paf,
281: pay_payroll_actions ppa1,

Line 365: ff_database_items fdi1 --database_items for City_withheld

361: pay_payroll_actions ppa1,
362: ff_contexts fc1 , --for city context
363: ff_archive_items fai1, -- city
364: ff_archive_item_contexts faic1, -- city_context
365: ff_database_items fdi1 --database_items for City_withheld
366: --,pay_us_city_tax_info_f puctif
367: WHERE ppa1.payroll_action_id = p_pactid
368: AND ppa.business_group_id+0 = ppa1.business_group_id
369: AND ppa1.effective_date = ppa.effective_date