DBA Data[Home] [Help]

APPS.PAY_US_MMREF_LOCAL_XML dependencies on FF_ARCHIVE_ITEMS

Line 140: FROM ff_archive_items FAI,

136: CURSOR local_w2_xml_employee
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,

Line 199: FROM ff_archive_items FAI,

195: 'EE_ASSIGNMENT_ID=P', AA.assignment_id,
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,