DBA Data[Home] [Help]

APPS.PAY_US_MMREF_LOCAL_XML dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 276: FROM ff_archive_item_contexts faic,

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

Line 365: ff_archive_item_contexts faic1, -- city_context

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
369: AND ppa.business_group_id+0 = ppa1.business_group_id

Line 429: ff_archive_item_contexts faic1, -- city_context

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
433: AND ppa.business_group_id+0 = ppa1.business_group_id