DBA Data[Home] [Help]

APPS.PAY_US_MMREF_LOCAL_XML dependencies on FF_CONTEXTS

Line 141: ff_contexts FC, -- JD

137: IS
138: SELECT DISTINCT
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,

Line 200: ff_contexts FC, -- JD

196: 'EE_DATE_EARNED=P', pay_magtape_generic.date_earned(PA.effective_date,
197: AA.assignment_id),
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,