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

Line 126: FROM pay_payroll_actions ppa

122: p_year_end,
123: p_business_group_id,
124: p_report_type,
125: p_legislative_param
126: FROM pay_payroll_actions ppa
127: WHERE payroll_action_id = p_pactid;
128:
129: hr_utility.set_location('pay_ca_rl2_amend_mag.get_report_parameters', 20);
130:

Line 153: pay_payroll_actions ppa

149: CURSOR cur_arch_pactid(p_transmitter_org_id NUMBER) IS
150: SELECT
151: ppa.payroll_action_id
152: FROM
153: pay_payroll_actions ppa
154: WHERE
155: ppa.business_group_id = p_bg_id AND
156: ppa.report_type = 'CAEOY_RL2_AMEND_PP' AND
157: ppa.report_qualifier = 'CAEOY_RL2_AMEND_PPQ' AND

Line 172: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

168: dummy NUMBER;
169: dummy1 VARCHAR2(10);
170: l_transmitter_org_id NUMBER;
171: l_arch_pactid NUMBER;
172: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
173: l_address_line1 per_addresses.address_line1%TYPE;
174:
175: CURSOR cur_ppa IS
176: SELECT

Line 179: pay_payroll_actions ppa

175: CURSOR cur_ppa IS
176: SELECT
177: ppa.legislative_parameters
178: FROM
179: pay_payroll_actions ppa
180: WHERE
181: ppa.payroll_action_id = p_payroll_action_id;
182:
183: CURSOR get_trans_details(p_pactid NUMBER,

Line 295: p_legislative_param pay_payroll_actions.legislative_parameters%type;

291: p_year_start DATE;
292: p_year_end DATE;
293: p_business_group_id NUMBER;
294: p_report_type VARCHAR2(30);
295: p_legislative_param pay_payroll_actions.legislative_parameters%type;
296:
297: BEGIN
298:
299: hr_utility.set_location( 'pay_ca_rl2_amend_mag.range_cursor', 10);

Line 315: pay_payroll_actions ppa_arch,

311: p_sqlstr := 'select distinct to_number(emp.person_id)
312: from pay_ca_eoy_rl2_employee_info_v emp,
313: pay_ca_eoy_rl2_trans_info_v tran,
314: pay_assignment_actions paa_arch,
315: pay_payroll_actions ppa_arch,
316: pay_payroll_actions ppa_mag,
317: hr_organization_information hoi
318: where ppa_mag.payroll_action_id = :payroll_action_id
319: and ppa_arch.business_group_id+0 = ppa_mag.business_group_id

Line 316: pay_payroll_actions ppa_mag,

312: from pay_ca_eoy_rl2_employee_info_v emp,
313: pay_ca_eoy_rl2_trans_info_v tran,
314: pay_assignment_actions paa_arch,
315: pay_payroll_actions ppa_arch,
316: pay_payroll_actions ppa_mag,
317: hr_organization_information hoi
318: where ppa_mag.payroll_action_id = :payroll_action_id
319: and ppa_arch.business_group_id+0 = ppa_mag.business_group_id
320: and ppa_arch.effective_date = ppa_mag.effective_date

Line 377: FROM pay_payroll_actions ppa_arch,

373: hoi.organization_id,
374: paf.effective_end_date,
375: max(paa_arch.assignment_action_id),
376: max(ppa_arch.payroll_action_id)
377: FROM pay_payroll_actions ppa_arch,
378: pay_assignment_actions paa_arch,
379: per_all_assignments_f paf,
380: hr_organization_information hoi
381: WHERE ppa_arch.report_type = 'CAEOY_RL2_AMEND_PP'

Line 402: pay_payroll_actions pact,

398: AND paf1.effective_start_date <= p_effective_dt)
399: AND not exists
400: ( SELECT pail.locked_action_id
401: FROM pay_action_interlocks pail,
402: pay_payroll_actions pact,
403: pay_assignment_actions passt
404: WHERE pact.report_type = 'RL2_AMEND_MAG'
405: AND pact.payroll_action_id = passt.payroll_action_id
406: AND passt.assignment_action_id = pail.locking_action_id

Line 411: pay_payroll_actions pact,

407: AND pail.locked_action_id = paa_arch.assignment_action_id)
408: AND not exists
409: ( SELECT pail.locked_action_id
410: FROM pay_action_interlocks pail,
411: pay_payroll_actions pact,
412: pay_assignment_actions passt
413: WHERE pact.report_type = 'RL2_XML_MAG'
414: AND pact.payroll_action_id = passt.payroll_action_id
415: AND passt.assignment_action_id = pail.locking_action_id

Line 420: pay_payroll_actions pact,

416: AND pail.locked_action_id = paa_arch.assignment_action_id)
417: AND not exists
418: ( SELECT pail.locked_action_id
419: FROM pay_action_interlocks pail,
420: pay_payroll_actions pact,
421: pay_assignment_actions passt
422: WHERE pact.report_type = 'CAEOY_RL2_AMEND_PP'
423: AND pact.payroll_action_id = passt.payroll_action_id
424: AND passt.assignment_action_id = pail.locking_action_id

Line 441: from pay_payroll_actions ppa,

437: paa.assignment_id,
438: paa.assignment_action_id,
439: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
440: ppa.legislative_parameters)
441: from pay_payroll_actions ppa,
442: pay_assignment_actions paa
443: where paa.serial_number = to_char(cp_person_id)
444: /* and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
445: ppa.legislative_parameters) =

Line 461: pay_payroll_actions pact,

457: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
458: AND not exists
459: ( SELECT pail.locked_action_id
460: FROM pay_action_interlocks pail,
461: pay_payroll_actions pact,
462: pay_assignment_actions passt
463: WHERE pact.report_type = 'RL2_AMEND_MAG'
464: AND pact.payroll_action_id = passt.payroll_action_id
465: AND passt.assignment_action_id = pail.locking_action_id

Line 480: from pay_payroll_actions

476: CURSOR get_yepp_pact_id(cp_bg_id number,
477: cp_pre number,
478: cp_year date) IS
479: select payroll_action_id
480: from pay_payroll_actions
481: where business_group_id = cp_bg_id
482: and report_type = 'RL2'
483: and report_qualifier = 'CAEOYRL2'
484: and action_type = 'X'

Line 537: l_legislative_param pay_payroll_actions.legislative_parameters%type;

533: l_quebec_no VARCHAR2(20);
534: l_file_no VARCHAR2(10);
535: l_return NUMBER;
536: l_addr_line VARCHAR2(240);
537: l_legislative_param pay_payroll_actions.legislative_parameters%type;
538:
539: ln_primary_assignment_id NUMBER := 0;
540: lv_report_type pay_payroll_actions.report_type%TYPE ;
541: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

Line 540: lv_report_type pay_payroll_actions.report_type%TYPE ;

536: l_addr_line VARCHAR2(240);
537: l_legislative_param pay_payroll_actions.legislative_parameters%type;
538:
539: ln_primary_assignment_id NUMBER := 0;
540: lv_report_type pay_payroll_actions.report_type%TYPE ;
541: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
542: ln_pre_id_null number;
543: ln_iteration number := 0;
544: lv_flag_count number := 0;

Line 898: l_legislative_param pay_payroll_actions.legislative_parameters%type;

894: l_year_start DATE;
895: l_year_end DATE;
896: l_report_type VARCHAR2(20);
897: l_business_grpid NUMBER;
898: l_legislative_param pay_payroll_actions.legislative_parameters%type;
899: /* Bug 4777374 Fix */
900: l_Informatique_tag CHAR(1);
901: l_Comptabilite_tag CHAR(1);
902: /* Bug 4906963 Fix */

Line 1338: pay_payroll_actions ppa

1334: ppa.report_type,
1335: ppa.business_group_id,
1336: ppa.legislative_parameters
1337: FROM
1338: pay_payroll_actions ppa
1339: WHERE
1340: ppa.payroll_action_id = p_payactid;
1341:
1342: CURSOR c_get_employer_info(p_pact_id NUMBER,

Line 1370: pay_payroll_actions ppa,

1366: -- date_earned
1367: FROM
1368: pay_action_interlocks pai,
1369: pay_assignment_actions paa,
1370: pay_payroll_actions ppa,
1371: per_all_people_f ppf,
1372: per_all_assignments_f paf,
1373: pay_action_information pact
1374: WHERE paa.assignment_action_id = pai.locking_action_id

Line 1664: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;

1660: l_authorisation_tag NUMBER;
1661: l_sequence_no NUMBER;
1662: l_seq_num NUMBER;
1663: l_authorization_code VARCHAR2(100);
1664: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
1665: l_transmitter_org_id NUMBER;
1666: BEGIN
1667: --hr_utility.trace_on(null,'SATIRL2XML');
1668: hr_utility.trace('Inside the Employee record proc');

Line 2863: l_legislative_param pay_payroll_actions.legislative_parameters%type;

2859: l_year_start DATE;
2860: l_year_end DATE;
2861: l_report_type VARCHAR2(20);
2862: l_business_grpid NUMBER;
2863: l_legislative_param pay_payroll_actions.legislative_parameters%type;
2864: EOL varchar2(5);
2865: l_employer_name varchar2(100);
2866: l_quebec_bn varchar2(20);
2867: l_address_line1 per_addresses.address_line1%TYPE;

Line 3240: FROM pay_payroll_actions

3236: PROCEDURE archive_ca_deinit (p_pactid IN NUMBER) IS
3237:
3238: CURSOR c_get_report_type ( p_pactid number) IS
3239: SELECT report_type
3240: FROM pay_payroll_actions
3241: WHERE payroll_action_id = p_pactid;
3242:
3243: l_report_type pay_payroll_actions.report_type%type;
3244:

Line 3243: l_report_type pay_payroll_actions.report_type%type;

3239: SELECT report_type
3240: FROM pay_payroll_actions
3241: WHERE payroll_action_id = p_pactid;
3242:
3243: l_report_type pay_payroll_actions.report_type%type;
3244:
3245: BEGIN
3246:
3247: open c_get_report_type(p_pactid);