APPS.PAY_US_MMREF_LOCAL_XML dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 275: FROM ff_archive_item_contexts faic,

271: IF p_report_type = 'W2_MAG_XML' THEN
272: p_sqlstr := '
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,

Line 364: ff_archive_item_contexts faic1, -- city_context

360: per_all_assignments_f paf,
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