DBA Data[Home] [Help]

APPS.PAY_US_MMREF_LOCAL_XML dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 143: ff_archive_item_contexts FAIC,

139: 'TRANSFER_ACT_ID=P', AA.assignment_action_id
140: FROM ff_archive_items FAI,
141: ff_contexts FC, -- JD
142: ff_database_items FDI,
143: ff_archive_item_contexts FAIC,
144: per_all_people_f PE,
145: per_all_assignments_f SS,
146: pay_action_interlocks AI,
147: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions

Line 202: ff_archive_item_contexts FAIC,

198: 'EE_LOCALITY_JD_CODE=P', substr(ltrim(rtrim(faic.context)),1,2)||'-000-'||substr(ltrim(rtrim(faic.context)),8,4)
199: FROM ff_archive_items FAI,
200: ff_contexts FC, -- JD
201: ff_database_items FDI,
202: ff_archive_item_contexts FAIC,
203: per_all_people_f PE,
204: per_all_assignments_f SS,
205: pay_action_interlocks AI,
206: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions