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_EOY_T4A_AMEND_REG dependencies on PAY_PAYROLL_ACTIONS

Line 81: from pay_payroll_actions ppa

77: effective_date,
78: start_date,
79: business_group_id,
80: report_type
81: from pay_payroll_actions ppa
82: where ppa.payroll_action_id = cp_payroll_action_id;
83:
84: ld_end_date DATE;
85: ld_start_date DATE;

Line 204: from pay_payroll_actions ppa_arch,

200: elsif ln_tax_unit_id is not NULL then
201:
202: lv_sql_string :=
203: 'select distinct paf.person_id
204: from pay_payroll_actions ppa_arch,
205: pay_assignment_actions paa_arch,
206: per_assignments_f paf,
207: pay_payroll_actions ppa
208: where paa_arch.assignment_id = paf.assignment_id

Line 207: pay_payroll_actions ppa

203: 'select distinct paf.person_id
204: from pay_payroll_actions ppa_arch,
205: pay_assignment_actions paa_arch,
206: per_assignments_f paf,
207: pay_payroll_actions ppa
208: where paa_arch.assignment_id = paf.assignment_id
209: and ppa.payroll_action_id = :p_payroll_action_id
210: and ppa_arch.business_group_id = ppa.business_group_id
211: and ppa_arch.effective_date = ppa.effective_date

Line 222: from pay_payroll_actions ppa_arch,

218: else
219:
220: lv_sql_string :=
221: 'select distinct paf.person_id
222: from pay_payroll_actions ppa_arch,
223: pay_assignment_actions paa_arch,
224: per_assignments_f paf,
225: pay_payroll_actions ppa
226: where paa_arch.assignment_id = paf.assignment_id

Line 225: pay_payroll_actions ppa

221: 'select distinct paf.person_id
222: from pay_payroll_actions ppa_arch,
223: pay_assignment_actions paa_arch,
224: per_assignments_f paf,
225: pay_payroll_actions ppa
226: where paa_arch.assignment_id = paf.assignment_id
227: and ppa.payroll_action_id = :p_payroll_action_id
228: and ppa_arch.business_group_id = ppa.business_group_id
229: and ppa_arch.effective_date = ppa.effective_date

Line 279: lv_report_type pay_payroll_actions.report_type%TYPE ;

275: ln_set_person_id NUMBER := 0 ;
276: ln_asg_set NUMBER := 0 ;
277: lv_print varchar2(10);
278:
279: lv_report_type pay_payroll_actions.report_type%TYPE ;
280: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
281:
282: lv_employee_number per_people_f.employee_number%type;
283: lv_message varchar2(100):= null;

Line 298: pay_payroll_actions ppa,

294: ,cp_effective_date in date) is
295: select distinct paf.person_id
296: from hr_assignment_set_amendments asgset,
297: per_assignments_f paf,
298: pay_payroll_actions ppa,
299: pay_assignment_actions paa
300: where asgset.assignment_set_id = cp_asg_set
301: and asgset.include_or_exclude = 'I'
302: and paf.assignment_id = asgset.assignment_id

Line 328: FROM pay_payroll_actions ppa ,

324: >= cp_eff_date
325: AND hoi.org_information_context = 'Canada Employer Identification'
326: AND hoi.org_information5 in ('T4A/RL1','T4A/RL2')
327: AND exists ( SELECT 1
328: FROM pay_payroll_actions ppa ,
329: pay_assignment_actions paa
330: WHERE ppa.report_type = 'CAEOY_T4A_AMEND_PP'
331: AND ppa.report_qualifier = 'CAEOY_T4A_AMEND_PPQ'
332: AND ppa.business_group_id = cp_bg_id

Line 343: from pay_payroll_actions ppa_arch,

339: cp_eff_date date,
340: cp_start_person number,
341: cp_end_person number) is
342: select distinct paa_arch.serial_number
343: from pay_payroll_actions ppa_arch,
344: pay_assignment_actions paa_arch
345: where ppa_arch.business_group_id = cp_bg_id
346: and ppa_arch.report_type = 'CAEOY_T4A_AMEND_PP'
347: AND ppa_arch.report_qualifier = 'CAEOY_T4A_AMEND_PPQ'

Line 367: from pay_payroll_actions ppa,

363: select ppa.report_type,
364: paa.assignment_id,
365: paa.assignment_action_id,
366: paa.tax_unit_id
367: from pay_payroll_actions ppa,
368: pay_assignment_actions paa
369: where paa.serial_number = to_char(cp_person_id)
370: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
371: and ppa.business_group_id = ln_business_group_id

Line 393: from pay_payroll_actions ppa,

389: select ppa.report_type,
390: paa.assignment_id,
391: paa.assignment_action_id,
392: paa.tax_unit_id
393: from pay_payroll_actions ppa,
394: pay_assignment_actions paa
395: where paa.serial_number = to_char(cp_person_id)
396: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
397: and ppa.business_group_id = ln_business_group_id

Line 414: from pay_payroll_actions

410: CURSOR get_yepp_pact_id(cp_bg_id number,
411: cp_gre number,
412: cp_year date) IS
413: select payroll_action_id
414: from pay_payroll_actions
415: where business_group_id = cp_bg_id
416: and report_type = 'T4A'
417: and report_qualifier = 'CAEOY'
418: and action_type = 'X'

Line 836: pay_payroll_actions ppa1

832: hr_locations_all loc,
833: per_all_people_f ppf,
834: per_all_assignments_f paf,
835: pay_assignment_actions paa1,
836: pay_payroll_actions ppa1
837: where ppa1.payroll_action_id = :p_payroll_action_id
838: and paa1.payroll_action_id = ppa1.payroll_action_id
839: and paa1.assignment_id = paf.assignment_id
840: and paf.effective_start_date =

Line 885: token_val pay_payroll_actions.legislative_parameters%type;

881: parameter_list varchar2) return varchar2
882: IS
883: start_ptr number;
884: end_ptr number;
885: token_val pay_payroll_actions.legislative_parameters%type;
886: par_value pay_payroll_actions.legislative_parameters%type;
887:
888: BEGIN
889:

Line 886: par_value pay_payroll_actions.legislative_parameters%type;

882: IS
883: start_ptr number;
884: end_ptr number;
885: token_val pay_payroll_actions.legislative_parameters%type;
886: par_value pay_payroll_actions.legislative_parameters%type;
887:
888: BEGIN
889:
890: token_val := name||'=';