DBA Data[Home] [Help]

APPS.PAY_US_MMREF_LOCAL_XML dependencies on FF_DATABASE_ITEMS

Line 147: ff_database_items FDI,

143: SELECT DISTINCT
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,

Line 198: ff_database_items FDI,

194: SELECT DISTINCT
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,

Line 256: ff_database_items FDI,

252: AA.assignment_id),
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,