eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KR_SPAY_EFILE dependencies on FF_ARCHIVE_ITEMS

Line 201: ,ff_archive_items fai

197: ,hr_organization_information hoi
198: ,hr_organization_information ihoi
199: ,hr_organization_units hou
200: ,ff_user_entities fue
201: ,ff_archive_items fai
202: WHERE xppa.action_type = 'X'
203: and xppa.action_status = 'C'
204: and xppa.effective_date between
205: -- Bug 4253329

Line 238: ,ff_archive_items fai1

234: and fai.context1= xpaa.assignment_action_id
235: -- 3627111
236: and not exists ( select 'x'
237: from ff_user_entities fue1
238: ,ff_archive_items fai1
239: where fue1.user_entity_name in ('A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN','A_RECEIVABLE_NON_STAT_SEP_PAY_ASG_RUN')
240: and fue1.legislation_code = 'KR'
241: and fai1.user_entity_id = fue1.user_entity_id
242: and fai1.context1 = xpaa.assignment_action_id

Line 323: ,ff_archive_items fai

319: ,hr_organization_information hoi
320: ,hr_organization_information ihoi
321: ,hr_organization_units hou
322: ,ff_user_entities fue
323: ,ff_archive_items fai
324: WHERE xppa.action_type = 'X'
325: and xppa.action_status = 'C'
326: and xppa.effective_date between
327: -- Bug 4253329

Line 363: ,ff_archive_items fai2

359: and prt.run_type_id = paa.run_type_id -- Bug 4201616
360: -- 3627111
361: and exists ( select 'x'
362: from ff_user_entities fue2
363: ,ff_archive_items fai2
364: where fue2.user_entity_name in ('A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN','A_RECEIVABLE_SEPARATION_PAY_ASG_RUN')
365: and fue2.legislation_code = 'KR'
366: and fai2.user_entity_id = fue2.user_entity_id
367: and fai2.context1 = xpaa.assignment_action_id

Line 371: ,ff_archive_items fai1

367: and fai2.context1 = xpaa.assignment_action_id
368: and fai2.value > '0' )
369: and not exists ( select 'x'
370: from ff_user_entities fue1
371: ,ff_archive_items fai1
372: where fue1.user_entity_name in ('A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN','A_RECEIVABLE_NON_STAT_SEP_PAY_ASG_RUN')
373: and fue1.legislation_code = 'KR'
374: and fai1.user_entity_id = fue1.user_entity_id
375: and fai1.context1 = xpaa.assignment_action_id

Line 390: ff_archive_items fai

386: ff_contexts fc,
387: ff_user_entities fue,
388: ff_route_context_usages frc,
389: ff_archive_item_contexts fac,
390: ff_archive_items fai
391: where
392: fue.user_entity_name = 'X_KR_PREV_BP_NUMBER'
393: and fue.legislation_code = 'KR'
394: and fue.route_id = frc.route_id