APPS.PAY_US_MULTI_MMRF dependencies on FF_ARCHIVE_ITEMS

Line 121: FROM ff_archive_items fai,

117: 'A_TERRITORY_TAXABLE_TIPS_PER_GRE_YTD', nvl(sum(value),0) * 100
118: , 'A_W2_ROTH_401K_PER_GRE_YTD', nvl(sum(value),0) * 100
119: , 'A_W2_ROTH_403B_PER_GRE_YTD', nvl(sum(value),0) * 100
120: ) val
121: FROM ff_archive_items fai,
122: pay_action_interlocks pai,
123: pay_payroll_actions ppa,
124: pay_assignment_actions paa,
125: ff_user_entities fue

Line 197: ,ff_archive_items fai

193: 'A_SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD',nvl(sum(value),0) * 100,
194: 'A_SIT_PRE_TAX_REDNS_PER_JD_GRE_YTD',nvl(sum(value),0) * 100
195: ) val
196: FROM ff_archive_item_contexts faic
197: ,ff_archive_items fai
198: ,pay_assignment_actions paa
199: ,pay_payroll_actions ppa
200: ,pay_action_interlocks pai
201: ,ff_user_entities fue

Line 225: ,ff_archive_items fai

221: CURSOR c_ro_count ( cp_tax_unit_id number) IS
222: select count(*)
223: from pay_payroll_actions ppa
224: ,pay_assignment_actions paa
225: ,ff_archive_items fai
226: where ppa.report_type = 'W2'
227: and ppa.report_qualifier = 'FED'
228: and effective_date = to_date('31/12/'||w2_year,'dd/mm/yyyy')
229: and ppa.payroll_action_id = paa.payroll_action_id