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_T4_AMEND_REG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 178: ln_agent_tax_unit_id pay_assignment_actions.tax_unit_id%type;

174: lv_sql_string VARCHAR2(32000);
175: ln_eoy_pactid number;
176: lv_print varchar2(10):=null;
177: lv_error_mesg varchar2(100);
178: ln_agent_tax_unit_id pay_assignment_actions.tax_unit_id%type;
179: ln_year number;
180: lv_prov_cd varchar2(5);
181: lv_report_type varchar2(50);
182:

Line 232: pay_assignment_actions paa_arch,

228:
229: lv_sql_string :=
230: 'select distinct paf.person_id
231: from pay_payroll_actions ppa_arch,
232: pay_assignment_actions paa_arch,
233: per_assignments_f paf,
234: pay_payroll_actions ppa
235: where paa_arch.assignment_id = paf.assignment_id
236: and ppa.payroll_action_id = :payroll_action_id

Line 250: pay_assignment_actions paa_arch,

246:
247: lv_sql_string :=
248: 'select distinct paf.person_id
249: from pay_payroll_actions ppa_arch,
250: pay_assignment_actions paa_arch,
251: per_assignments_f paf,
252: pay_payroll_actions ppa
253: where paa_arch.assignment_id = paf.assignment_id
254: and ppa.payroll_action_id = :payroll_action_id

Line 309: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

305: lv_print varchar2(10);
306: lv_prov_cd varchar2(5);
307:
308: lv_report_type pay_payroll_actions.report_type%TYPE ;
309: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
310: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;
311: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
312:
313:

Line 310: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;

306: lv_prov_cd varchar2(5);
307:
308: lv_report_type pay_payroll_actions.report_type%TYPE ;
309: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
310: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;
311: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
312:
313:
314: lv_serial_number VARCHAR2(30);

Line 311: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;

307:
308: lv_report_type pay_payroll_actions.report_type%TYPE ;
309: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
310: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;
311: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
312:
313:
314: lv_serial_number VARCHAR2(30);
315: lv_employee_number per_people_f.employee_number%type;

Line 320: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;

316: lv_message varchar2(100):= null;
317: lv_full_name per_people_f.full_name%type;
318: lv_record_name varchar2(100);
319: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
320: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
321: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
322: ln_serial_number pay_assignment_actions.serial_number%TYPE;
323: ln_gre_id NUMBER;
324: ln_gre_parameter NUMBER;

Line 321: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;

317: lv_full_name per_people_f.full_name%type;
318: lv_record_name varchar2(100);
319: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
320: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
321: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
322: ln_serial_number pay_assignment_actions.serial_number%TYPE;
323: ln_gre_id NUMBER;
324: ln_gre_parameter NUMBER;
325: lv_ppr_report_type varchar2(50);

Line 322: ln_serial_number pay_assignment_actions.serial_number%TYPE;

318: lv_record_name varchar2(100);
319: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
320: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
321: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
322: ln_serial_number pay_assignment_actions.serial_number%TYPE;
323: ln_gre_id NUMBER;
324: ln_gre_parameter NUMBER;
325: lv_ppr_report_type varchar2(50);
326:

Line 335: pay_assignment_actions paa

331: select distinct paf.person_id
332: from hr_assignment_set_amendments asgset,
333: per_assignments_f paf,
334: pay_payroll_actions ppa,
335: pay_assignment_actions paa
336: where asgset.assignment_set_id = cp_asg_set
337: and asgset.include_or_exclude = 'I'
338: and paf.assignment_id = asgset.assignment_id
339: and paf.person_id between cp_start_person

Line 365: pay_assignment_actions paa

361: AND hoi.org_information_context = 'Canada Employer Identification'
362: AND hoi.org_information5 = 'T4/RL1'
363: AND exists ( SELECT 1
364: FROM pay_payroll_actions ppa ,
365: pay_assignment_actions paa
366: WHERE ppa.report_type = 'CAEOY_T4_AMEND_PP'
367: AND ppa.report_qualifier = 'CAEOY_T4_AMEND_PPQ'
368: AND ppa.business_group_id = cp_bg_id
369: AND ppa.effective_date = cp_eff_date

Line 380: pay_assignment_actions paa_arch

376: cp_start_person number,
377: cp_end_person number) is
378: select distinct paa_arch.serial_number
379: from pay_payroll_actions ppa_arch,
380: pay_assignment_actions paa_arch
381: where ppa_arch.business_group_id = cp_bg_id
382: and ppa_arch.report_type = 'CAEOY_T4_AMEND_PP'
383: AND ppa_arch.report_qualifier = 'CAEOY_T4_AMEND_PPQ'
384: and ppa_arch.effective_date = cp_eff_date

Line 405: pay_assignment_actions paa

401: paa.assignment_id,
402: paa.assignment_action_id,
403: paa.tax_unit_id
404: from pay_payroll_actions ppa,
405: pay_assignment_actions paa
406: where paa.serial_number = to_char(cp_person_id)
407: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
408: and ppa.business_group_id = ln_business_group_id
409: and paa.action_status = 'C'

Line 431: pay_assignment_actions paa

427: paa.assignment_id,
428: paa.assignment_action_id,
429: paa.tax_unit_id
430: from pay_payroll_actions ppa,
431: pay_assignment_actions paa
432: where paa.serial_number = to_char(cp_person_id)
433: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
434: and ppa.business_group_id = ln_business_group_id
435: and paa.action_status = 'C'

Line 581: select pay_assignment_actions_s.nextval

577: /* Create an assignment action for this person */
578: hr_utility.trace('get_latest_t4amend_dtls found ');
579: hr_utility.trace('Report Type: '||lv_report_type);
580:
581: select pay_assignment_actions_s.nextval
582: into ln_t4amend_reg_asg_action
583: from dual;
584:
585: hr_utility.trace('New T4 Amend Action = ' ||

Line 588: /* Insert into pay_assignment_actions. */

584:
585: hr_utility.trace('New T4 Amend Action = ' ||
586: to_char(ln_t4amend_reg_asg_action));
587:
588: /* Insert into pay_assignment_actions. */
589: hr_nonrun_asact.insact(ln_t4amend_reg_asg_action
590: ,ln_primary_assignment_id
591: ,p_payroll_action_id
592: ,p_chunk

Line 610: update pay_assignment_actions aa

606: ln_serial_number := lv_prov_of_emp||
607: lpad(to_char(ln_asg_act_to_lock),14,0)||
608: lpad(to_char(ln_yepp_pact_id),14,0);
609:
610: update pay_assignment_actions aa
611: set aa.serial_number = ln_serial_number
612: where aa.assignment_action_id = ln_t4amend_reg_asg_action;
613: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
614: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));

Line 690: select pay_assignment_actions_s.nextval

686: hr_utility.trace('Report Type: '||lv_report_type);
687:
688: /* Create an assignment action for this person */
689:
690: select pay_assignment_actions_s.nextval
691: into ln_t4amend_reg_asg_action
692: from dual;
693: hr_utility.trace('New T4 Amend Action = ' || ln_t4amend_reg_asg_action);
694:

Line 695: /* Insert into pay_assignment_actions. */

691: into ln_t4amend_reg_asg_action
692: from dual;
693: hr_utility.trace('New T4 Amend Action = ' || ln_t4amend_reg_asg_action);
694:
695: /* Insert into pay_assignment_actions. */
696: hr_nonrun_asact.insact(ln_t4amend_reg_asg_action
697: ,ln_primary_assignment_id
698: ,p_payroll_action_id
699: ,p_chunk

Line 720: update pay_assignment_actions aa

716: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
717: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
718: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
719:
720: update pay_assignment_actions aa
721: set aa.serial_number = ln_serial_number
722: where aa.assignment_action_id = ln_t4amend_reg_asg_action;
723:
724: end if; -- lv_amend_flag = 'Y' condition

Line 874: l_gre_id pay_assignment_actions.tax_unit_id%type;

870: ) is
871:
872: l_dt date;
873: l_year number ;
874: l_gre_id pay_assignment_actions.tax_unit_id%type;
875: l_per_id per_assignments_f.person_id%type;
876: l_sort1 varchar2(60);
877: l_sort2 varchar2(60);
878: l_sort3 varchar2(60);

Line 931: pay_assignment_actions paa1,

927: hr_all_organization_units hou1,
928: hr_locations_all loc,
929: per_all_people_f ppf,
930: per_all_assignments_f paf,
931: pay_assignment_actions paa1,
932: pay_payroll_actions ppa1
933: where ppa1.payroll_action_id = :p_payroll_action_id
934: and paa1.payroll_action_id = ppa1.payroll_action_id
935: and paa1.assignment_id = paf.assignment_id