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 111: ff_archive_items fai1,

107: select distinct to_number(fai2.value) tax_unit_id,
108: payroll_action_id arch_pactid,
109: ppa.effective_date
110: from pay_payroll_actions ppa,
111: ff_archive_items fai1,
112: ff_archive_items fai2
113: where fai1.user_entity_id = l_uid_caeoy_tax_year
114: and fai1.value = l_year
115: and fai2.context1 = fai1.context1

Line 112: ff_archive_items fai2

108: payroll_action_id arch_pactid,
109: ppa.effective_date
110: from pay_payroll_actions ppa,
111: ff_archive_items fai1,
112: ff_archive_items fai2
113: where fai1.user_entity_id = l_uid_caeoy_tax_year
114: and fai1.value = l_year
115: and fai2.context1 = fai1.context1
116: and fai2.user_entity_id = l_uid_caeoy_tax_unit_id

Line 128: ff_archive_items fai1,

124: cursor cur_gre is
125: select payroll_action_id arch_pactid,
126: ppa.effective_date
127: from pay_payroll_actions ppa,
128: ff_archive_items fai1,
129: ff_archive_items fai2
130: where fai1.user_entity_id = l_uid_caeoy_tax_year
131: and fai1.value = l_year
132: and ppa.payroll_action_id = fai1.context1

Line 129: ff_archive_items fai2

125: select payroll_action_id arch_pactid,
126: ppa.effective_date
127: from pay_payroll_actions ppa,
128: ff_archive_items fai1,
129: ff_archive_items fai2
130: where fai1.user_entity_id = l_uid_caeoy_tax_year
131: and fai1.value = l_year
132: and ppa.payroll_action_id = fai1.context1
133: and ppa.report_type = 'T4A'