DBA Data[Home] [Help]

APPS.PAY_US_MMREF_LOCAL_XML dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 148: ff_archive_item_contexts FAIC,

144: 'TRANSFER_ACT_ID=P', AA.assignment_action_id
145: FROM ff_archive_items FAI,
146: ff_contexts FC, -- JD
147: ff_database_items FDI,
148: ff_archive_item_contexts FAIC,
149: per_all_people_f PE,
150: per_all_assignments_f SS,
151: pay_action_interlocks AI,
152: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions

Line 199: ff_archive_item_contexts FAIC,

195: 'TRANSFER_ACT_ID=P', AA.assignment_action_id
196: FROM ff_archive_items FAI,
197: ff_contexts FC, -- JD
198: ff_database_items FDI,
199: ff_archive_item_contexts FAIC,
200: per_all_people_f PE,
201: per_all_assignments_f SS,
202: pay_action_interlocks AI,
203: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions

Line 257: ff_archive_item_contexts FAIC,

253: 'EE_LOCALITY_JD_CODE=P', substr(ltrim(rtrim(faic.context)),1,2)||'-000-'||substr(ltrim(rtrim(faic.context)),8,4)
254: FROM ff_archive_items FAI,
255: ff_contexts FC, -- JD
256: ff_database_items FDI,
257: ff_archive_item_contexts FAIC,
258: per_all_people_f PE,
259: per_all_assignments_f SS,
260: pay_action_interlocks AI,
261: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions