APPS.PAY_CA_T4_REG dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 106: l_prov_cd ff_archive_item_contexts.context%TYPE;

102: lockingactid number;
103: lockedactid number;
104: l_asg_set_id number;
105: l_asg_id number;
106: l_prov_cd ff_archive_item_contexts.context%TYPE;
107: l_province ff_archive_item_contexts.context%TYPE;
108: l_tax_unit_id number;
109: l_year varchar2(4);
110: l_bus_group_id number;

Line 107: l_province ff_archive_item_contexts.context%TYPE;

103: lockedactid number;
104: l_asg_set_id number;
105: l_asg_id number;
106: l_prov_cd ff_archive_item_contexts.context%TYPE;
107: l_province ff_archive_item_contexts.context%TYPE;
108: l_tax_unit_id number;
109: l_year varchar2(4);
110: l_bus_group_id number;
111: l_year_start date;

Line 182: ff_archive_item_contexts faic

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'
186: and paf.effective_start_date = (select max(paf2.effective_start_date)

Line 214: ff_archive_item_contexts faic

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'
218: and paf.effective_start_date = (select max(paf2.effective_start_date)

Line 247: ff_archive_item_contexts faic,

243: paa.payroll_action_id
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'