DBA Data[Home] [Help]

APPS.PAY_US_MMREF_LOCAL_XML dependencies on FF_DATABASE_ITEMS

Line 76: FROM ff_database_items DI,

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

Line 278: ff_database_items fdi,

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

Line 366: ff_database_items fdi1 --database_items for City_withheld

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

Line 430: ff_database_items fdi1

426: pay_payroll_actions ppa1,
427: ff_contexts fc1 , --for city context
428: ff_archive_items fai1, -- city
429: ff_archive_item_contexts faic1, -- city_context
430: ff_database_items fdi1
431:
432: WHERE ppa1.payroll_action_id = p_pactid
433: AND ppa.business_group_id+0 = ppa1.business_group_id
434: AND ppa1.effective_date = ppa.effective_date