DBA Data[Home] [Help]

APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on FF_ARCHIVE_ITEMS

Line 117: ,ff_archive_items fai

113: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
114: and ihoi.organization_id = hou.organization_id
115: and exists( select 'x'
116: from ff_user_entities fue
117: ,ff_archive_items fai
118: ,pay_assignment_actions xpaa
119: ,pay_payroll_actions xppa
120: where xppa.action_type = 'X'
121: and xppa.action_status = 'C'

Line 166: ff_archive_items fai

162: ff_contexts fc,
163: ff_user_entities fue,
164: ff_route_context_usages frc,
165: ff_archive_item_contexts fac,
166: ff_archive_items fai
167: where
168: fue.user_entity_name = 'X_KR_PREV_BP_NUMBER'
169: and fue.legislation_code = 'KR'
170: and fue.route_id = frc.route_id