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_ACTION_INTERLOCKS

Line 136: and exists (select distinct 'Y' from pay_action_interlocks pai,pay_assignment_actions paa2,pay_payroll_actions ppa2

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
139: and paa2.payroll_action_id = ppa2.payroll_action_id
140: and ppa2.effective_date = ppa.effective_date /*Added for 10381064*/

Line 152: and not exists (select distinct 'Y' from pay_action_interlocks pai,pay_assignment_actions paa2,pay_payroll_actions ppa2

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
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*/

Line 188: from pay_action_interlocks pail,

184: and decode(ppa1.report_type,l_amend_report_type,instr(ppa1.legislative_parameters,'MODE=LATEST'),1) <> 0)
185: and ((p_report_mode = 'LATEST'
186: and not exists
187: (select 1
188: from pay_action_interlocks pail,
189: pay_payroll_actions pact,
190: pay_assignment_actions passt
191: where pact.report_type = p_report_type
192: and pact.payroll_action_id = passt.payroll_action_id

Line 200: from pay_action_interlocks pail,

196: )
197: or (p_report_mode = 'REPRINT'
198: and exists
199: (select pail.locked_action_id
200: from pay_action_interlocks pail,
201: pay_payroll_actions pact,
202: pay_assignment_actions passt
203: where pact.report_type = p_report_type
204: and pact.payroll_action_id = passt.payroll_action_id