DBA Data[Home] [Help]

APPS.PAY_CA_T4_REG dependencies on FF_CONTEXTS

Line 181: ff_contexts fc,

177: paa.payroll_action_id
178: from per_assignments_f paf,
179: pay_assignment_actions paa,
180: ff_archive_items fai,
181: ff_contexts fc,
182: ff_archive_item_contexts faic
183: where paf.person_id between stperson
184: and endperson
185: and paf.primary_flag = 'Y'

Line 213: ff_contexts fc,

209: paa.payroll_action_id
210: from per_assignments_f paf,
211: pay_assignment_actions paa,
212: ff_archive_items fai,
213: ff_contexts fc,
214: ff_archive_item_contexts faic
215: where paf.person_id between stperson
216: and endperson
217: and paf.primary_flag = 'Y'

Line 248: ff_contexts fc

244: from per_assignments_f paf,
245: pay_assignment_actions paa,
246: ff_archive_items fai,
247: ff_archive_item_contexts faic,
248: ff_contexts fc
249: where paf.person_id >= stperson
250: and paf.person_id <= endperson
251: and paf.primary_flag = 'Y'
252: and paf.effective_start_date = (select max(paf2.effective_start_date)