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_PAYROLL_ACTIONS

Line 110: FUNCTION get_enable_template_flag (p_report_type in pay_payroll_actions.report_type%TYPE,

106: whether the Template Group field of T4 Amendment PDF,T4A Amendment PDF, RL1 Amendment
107: PDF and RL2 Amendment PDF Concurrent Programs based on the reports ran earlier for
108: the Employees*/
109:
110: FUNCTION get_enable_template_flag (p_report_type in pay_payroll_actions.report_type%TYPE,
111: p_reporting_year in VARCHAR2,
112: p_business_group_id in pay_payroll_actions.business_group_id%TYPE,
113: p_tax_unit_id in pay_assignment_actions.tax_unit_id%TYPE,
114: p_report_mode in VARCHAR2,

Line 112: p_business_group_id in pay_payroll_actions.business_group_id%TYPE,

108: the Employees*/
109:
110: FUNCTION get_enable_template_flag (p_report_type in pay_payroll_actions.report_type%TYPE,
111: p_reporting_year in VARCHAR2,
112: p_business_group_id in pay_payroll_actions.business_group_id%TYPE,
113: p_tax_unit_id in pay_assignment_actions.tax_unit_id%TYPE,
114: p_report_mode in VARCHAR2,
115: p_province in VARCHAR2)
116: RETURN VARCHAR2 IS

Line 128: from pay_payroll_actions ppa,

124: l_substr_st_pos NUMBER :=3;
125:
126: CURSOR get_template_flag IS
127: select distinct 'Y'
128: from pay_payroll_actions ppa,
129: pay_assignment_actions paa
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

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 143: and not exists (select 1 from pay_assignment_actions paa1,pay_payroll_actions ppa1

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*/
146: and paa1.assignment_id = paa.assignment_id
147: and paa1.assignment_action_id > paa.assignment_action_id

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 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)));

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
163: select distinct 'Y'
164: from pay_payroll_actions ppa,

Line 164: from pay_payroll_actions ppa,

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
163: select distinct 'Y'
164: from pay_payroll_actions ppa,
165: pay_assignment_actions paa
166: where ppa.report_type in (l_main_report_type,l_amend_report_type)
167: and to_char(ppa.effective_date,'YYYY') = p_reporting_year
168: and ppa.business_group_id = p_business_group_id

Line 176: pay_payroll_actions ppa1

172: and substr(paa.serial_number,1,2) = nvl(p_province,substr(paa.serial_number,1,2))
173: and not exists
174: (select 1
175: from pay_assignment_actions paa1,
176: pay_payroll_actions ppa1
177: where ppa1.report_type in (l_main_report_type,l_amend_report_type)
178: and ppa1.payroll_action_id = paa1.payroll_action_id
179: and ppa1.effective_date = ppa.effective_date
180: and paa1.tax_unit_id = paa.tax_unit_id

Line 189: pay_payroll_actions pact,

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
193: and pact.effective_date = ppa.effective_date

Line 201: pay_payroll_actions pact,

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
205: and pact.effective_date = ppa.effective_date

Line 309: FUNCTION get_enable_template_flag (p_report_type in pay_payroll_actions.report_type%TYPE,

305: END get_enable_template_flag;
306:
307: /*Added for Bug#10359114*/
308:
309: FUNCTION get_enable_template_flag (p_report_type in pay_payroll_actions.report_type%TYPE,
310: p_reporting_year in VARCHAR2,
311: p_business_group_id in pay_payroll_actions.business_group_id%TYPE,
312: p_tax_unit_id in pay_assignment_actions.tax_unit_id%TYPE,
313: p_report_mode in VARCHAR2)

Line 311: p_business_group_id in pay_payroll_actions.business_group_id%TYPE,

307: /*Added for Bug#10359114*/
308:
309: FUNCTION get_enable_template_flag (p_report_type in pay_payroll_actions.report_type%TYPE,
310: p_reporting_year in VARCHAR2,
311: p_business_group_id in pay_payroll_actions.business_group_id%TYPE,
312: p_tax_unit_id in pay_assignment_actions.tax_unit_id%TYPE,
313: p_report_mode in VARCHAR2)
314: RETURN VARCHAR2 IS
315: