eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_ARCHIVE_UTILS dependencies on PAY_CA_EOY_T4_AMEND_ARCH

Line 134: and to_number(pay_ca_eoy_t4_amend_arch.get_parameter(l_gre_or_pre,ppa.legislative_parameters))= nvl(p_tax_unit_id,to_number(pay_ca_eoy_t4_amend_arch.get_parameter(l_gre_or_pre,ppa.legislative_parameters)))

130: where ppa.report_type = l_archive_type
131: and to_char(ppa.effective_date,'YYYY') = p_reporting_year
132: and ppa.business_group_id = p_business_group_id
133: and ppa.payroll_action_id = paa.payroll_action_id
134: and to_number(pay_ca_eoy_t4_amend_arch.get_parameter(l_gre_or_pre,ppa.legislative_parameters))= nvl(p_tax_unit_id,to_number(pay_ca_eoy_t4_amend_arch.get_parameter(l_gre_or_pre,ppa.legislative_parameters)))
135: and ((p_report_mode = 'REPRINT'
136: and exists (select distinct 'Y' from pay_action_interlocks pai,pay_assignment_actions paa2,pay_payroll_actions ppa2
137: where pai.locked_action_id = paa.assignment_action_id
138: and pai.locking_action_id = paa2.assignment_action_id

Line 141: and paa2.tax_unit_id = nvl(paa.tax_unit_id,pay_ca_eoy_t4_amend_arch.get_parameter(l_gre_or_pre,ppa.legislative_parameters))

137: where pai.locked_action_id = paa.assignment_action_id
138: and pai.locking_action_id = paa2.assignment_action_id
139: and paa2.payroll_action_id = ppa2.payroll_action_id
140: and ppa2.effective_date = ppa.effective_date /*Added for 10381064*/
141: and paa2.tax_unit_id = nvl(paa.tax_unit_id,pay_ca_eoy_t4_amend_arch.get_parameter(l_gre_or_pre,ppa.legislative_parameters))
142: and ppa2.report_type = p_report_type)
143: and not exists (select 1 from pay_assignment_actions paa1,pay_payroll_actions ppa1
144: where ppa1.payroll_action_id = paa1.payroll_action_id
145: and ppa1.effective_date = ppa.effective_date /*Added for 10381064*/

Line 148: and nvl(paa1.tax_unit_id,pay_ca_eoy_t4_amend_arch.get_parameter(l_gre_or_pre,ppa1.legislative_parameters))

144: where ppa1.payroll_action_id = paa1.payroll_action_id
145: and ppa1.effective_date = ppa.effective_date /*Added for 10381064*/
146: and paa1.assignment_id = paa.assignment_id
147: and paa1.assignment_action_id > paa.assignment_action_id
148: and nvl(paa1.tax_unit_id,pay_ca_eoy_t4_amend_arch.get_parameter(l_gre_or_pre,ppa1.legislative_parameters))
149: = nvl(paa.tax_unit_id,pay_ca_eoy_t4_amend_arch.get_parameter(l_gre_or_pre,ppa.legislative_parameters))
150: and ppa1.report_type = l_archive_type))
151: or (p_report_mode = 'LATEST'
152: and not exists (select distinct 'Y' from pay_action_interlocks pai,pay_assignment_actions paa2,pay_payroll_actions ppa2

Line 149: = nvl(paa.tax_unit_id,pay_ca_eoy_t4_amend_arch.get_parameter(l_gre_or_pre,ppa.legislative_parameters))

145: and ppa1.effective_date = ppa.effective_date /*Added for 10381064*/
146: and paa1.assignment_id = paa.assignment_id
147: and paa1.assignment_action_id > paa.assignment_action_id
148: and nvl(paa1.tax_unit_id,pay_ca_eoy_t4_amend_arch.get_parameter(l_gre_or_pre,ppa1.legislative_parameters))
149: = nvl(paa.tax_unit_id,pay_ca_eoy_t4_amend_arch.get_parameter(l_gre_or_pre,ppa.legislative_parameters))
150: and ppa1.report_type = l_archive_type))
151: or (p_report_mode = 'LATEST'
152: and not exists (select distinct 'Y' from pay_action_interlocks pai,pay_assignment_actions paa2,pay_payroll_actions ppa2
153: where pai.locked_action_id = paa.assignment_action_id

Line 157: and nvl(paa2.tax_unit_id,pay_ca_eoy_t4_amend_arch.get_parameter(l_gre_or_pre,ppa2.legislative_parameters))

153: where pai.locked_action_id = paa.assignment_action_id
154: and pai.locking_action_id = paa2.assignment_action_id
155: and paa2.payroll_action_id = ppa2.payroll_action_id
156: and ppa2.effective_date = ppa.effective_date /*Added for 10381064*/
157: and nvl(paa2.tax_unit_id,pay_ca_eoy_t4_amend_arch.get_parameter(l_gre_or_pre,ppa2.legislative_parameters))
158: = nvl(paa.tax_unit_id,pay_ca_eoy_t4_amend_arch.get_parameter(l_gre_or_pre,ppa.legislative_parameters))
159: and ppa2.report_type in (l_archive_type,p_report_type) )
160: and ppa.payroll_action_id = (select max(payroll_action_id) from pay_payroll_actions ppa1 where ppa1.payroll_action_id = ppa.payroll_action_id)));
161: /*Added for Bug#10359114*/

Line 158: = nvl(paa.tax_unit_id,pay_ca_eoy_t4_amend_arch.get_parameter(l_gre_or_pre,ppa.legislative_parameters))

154: and pai.locking_action_id = paa2.assignment_action_id
155: and paa2.payroll_action_id = ppa2.payroll_action_id
156: and ppa2.effective_date = ppa.effective_date /*Added for 10381064*/
157: and nvl(paa2.tax_unit_id,pay_ca_eoy_t4_amend_arch.get_parameter(l_gre_or_pre,ppa2.legislative_parameters))
158: = nvl(paa.tax_unit_id,pay_ca_eoy_t4_amend_arch.get_parameter(l_gre_or_pre,ppa.legislative_parameters))
159: and ppa2.report_type in (l_archive_type,p_report_type) )
160: and ppa.payroll_action_id = (select max(payroll_action_id) from pay_payroll_actions ppa1 where ppa1.payroll_action_id = ppa.payroll_action_id)));
161: /*Added for Bug#10359114*/
162: CURSOR get_cancel_template_flag IS