DBA Data[Home] [Help]

APPS.PAY_US_MMREF_LOCAL_XML dependencies on FF_ARCHIVE_ITEMS

Line 277: ff_archive_items fai,

273: p_sqlstr := '
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,

Line 364: ff_archive_items fai1, -- city

360: pay_payroll_actions ppa, -- YREND PPA
361: per_all_assignments_f paf,
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

Line 428: ff_archive_items fai1, -- city

424: pay_payroll_actions ppa, -- YREND PPA
425: per_all_assignments_f paf,
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