APPS.PAY_CA_T4A_REG dependencies on FF_ARCHIVE_ITEMS

Line 57: from ff_archive_items fai1,

53: l_uid_tax_unit_id := get_user_entity_id('CAEOY_TAX_UNIT_ID');
54: l_uid_person_id := get_user_entity_id('CAEOY_PERSON_ID');
55:
56: sqlstr := 'select distinct to_number(fai3.value)
57: from ff_archive_items fai1,
58: ff_archive_items fai2,
59: ff_archive_items fai3,
60: pay_payroll_actions ppa,
61: pay_assignment_actions paa

Line 58: ff_archive_items fai2,

54: l_uid_person_id := get_user_entity_id('CAEOY_PERSON_ID');
55:
56: sqlstr := 'select distinct to_number(fai3.value)
57: from ff_archive_items fai1,
58: ff_archive_items fai2,
59: ff_archive_items fai3,
60: pay_payroll_actions ppa,
61: pay_assignment_actions paa
62: where ppa.payroll_action_id = :payroll_action_id

Line 59: ff_archive_items fai3,

55:
56: sqlstr := 'select distinct to_number(fai3.value)
57: from ff_archive_items fai1,
58: ff_archive_items fai2,
59: ff_archive_items fai3,
60: pay_payroll_actions ppa,
61: pay_assignment_actions paa
62: where ppa.payroll_action_id = :payroll_action_id
63: and fai1.user_entity_id = ' || l_uid_tax_year ||

Line 123: ff_archive_items fai1,

119: select distinct to_number(fai2.value) tax_unit_id,
120: payroll_action_id arch_pactid,
121: ppa.effective_date
122: from pay_payroll_actions ppa,
123: ff_archive_items fai1,
124: ff_archive_items fai2
125: where fai1.user_entity_id = l_uid_caeoy_tax_year
126: and fai1.value = l_year
127: and fai2.context1 = fai1.context1

Line 124: ff_archive_items fai2

120: payroll_action_id arch_pactid,
121: ppa.effective_date
122: from pay_payroll_actions ppa,
123: ff_archive_items fai1,
124: ff_archive_items fai2
125: where fai1.user_entity_id = l_uid_caeoy_tax_year
126: and fai1.value = l_year
127: and fai2.context1 = fai1.context1
128: and fai2.user_entity_id = l_uid_caeoy_tax_unit_id

Line 140: ff_archive_items fai1,

136: cursor cur_gre is
137: select payroll_action_id arch_pactid,
138: ppa.effective_date
139: from pay_payroll_actions ppa,
140: ff_archive_items fai1,
141: ff_archive_items fai2
142: where fai1.user_entity_id = l_uid_caeoy_tax_year
143: and fai1.value = l_year
144: and ppa.payroll_action_id = fai1.context1

Line 141: ff_archive_items fai2

137: select payroll_action_id arch_pactid,
138: ppa.effective_date
139: from pay_payroll_actions ppa,
140: ff_archive_items fai1,
141: ff_archive_items fai2
142: where fai1.user_entity_id = l_uid_caeoy_tax_year
143: and fai1.value = l_year
144: and ppa.payroll_action_id = fai1.context1
145: and ppa.report_type = 'T4A'