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

Line 117: FROM pay_payroll_actions ppa

113: p_year_end,
114: p_business_group_id,
115: p_report_type,
116: p_legislative_param
117: FROM pay_payroll_actions ppa
118: WHERE payroll_action_id = p_pactid;
119:
120: hr_utility.set_location('pay_ca_rl2_mag.get_report_parameters', 20);
121:

Line 144: pay_payroll_actions ppa

140: CURSOR cur_arch_pactid(p_transmitter_org_id NUMBER) IS
141: SELECT
142: ppa.payroll_action_id
143: FROM
144: pay_payroll_actions ppa
145: WHERE
146: ppa.business_group_id = p_bg_id AND
147: ppa.report_type = 'RL2' AND
148: ppa.report_qualifier = 'CAEOYRL2' AND

Line 163: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

159: dummy NUMBER;
160: dummy1 VARCHAR2(10);
161: l_transmitter_org_id NUMBER;
162: l_arch_pactid NUMBER;
163: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
164: l_address_line1 per_addresses.address_line1%TYPE;
165:
166: CURSOR cur_ppa IS
167: SELECT

Line 170: pay_payroll_actions ppa

166: CURSOR cur_ppa IS
167: SELECT
168: ppa.legislative_parameters
169: FROM
170: pay_payroll_actions ppa
171: WHERE
172: ppa.payroll_action_id = p_payroll_action_id;
173:
174: BEGIN

Line 281: p_legislative_param pay_payroll_actions.legislative_parameters%type;

277: p_year_start DATE;
278: p_year_end DATE;
279: p_business_group_id NUMBER;
280: p_report_type VARCHAR2(30);
281: p_legislative_param pay_payroll_actions.legislative_parameters%type;
282:
283: BEGIN
284:
285: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor', 10);

Line 305: pay_payroll_actions ppa_arch,

301: */ distinct to_number(emp.person_id)
302: from pay_ca_eoy_rl2_employee_info_v emp,
303: pay_ca_eoy_rl2_trans_info_v tran,
304: pay_assignment_actions paa_arch,
305: pay_payroll_actions ppa_arch,
306: pay_payroll_actions ppa_mag,
307: hr_organization_information hoi
308: where ppa_mag.payroll_action_id = :payroll_action_id
309: and ppa_arch.business_group_id+0 = ppa_mag.business_group_id

Line 306: pay_payroll_actions ppa_mag,

302: from pay_ca_eoy_rl2_employee_info_v emp,
303: pay_ca_eoy_rl2_trans_info_v tran,
304: pay_assignment_actions paa_arch,
305: pay_payroll_actions ppa_arch,
306: pay_payroll_actions ppa_mag,
307: hr_organization_information hoi
308: where ppa_mag.payroll_action_id = :payroll_action_id
309: and ppa_arch.business_group_id+0 = ppa_mag.business_group_id
310: and ppa_arch.effective_date = ppa_mag.effective_date

Line 367: FROM pay_payroll_actions ppa_arch,

363: paa_arch.tax_unit_id,
364: paf.effective_end_date,
365: paa_arch.assignment_action_id,
366: ppa_arch.payroll_action_id
367: FROM pay_payroll_actions ppa_arch,
368: pay_assignment_actions paa_arch,
369: per_all_assignments_f paf,
370: hr_organization_information hoi
371: WHERE ppa_arch.report_type = 'RL2'

Line 410: l_legislative_param pay_payroll_actions.legislative_parameters%type;

406: l_quebec_no VARCHAR2(20);
407: l_file_no VARCHAR2(10);
408: l_return NUMBER;
409: l_addr_line VARCHAR2(240);
410: l_legislative_param pay_payroll_actions.legislative_parameters%type;
411:
412: BEGIN
413:
414: -- hr_utility.trace_on(NULL,'RL2MAG');

Line 544: token_val pay_payroll_actions.legislative_parameters%type;

540: FUNCTION get_parameter(name IN varchar2, parameter_list varchar2)
541: RETURN varchar2 IS
542: start_ptr number;
543: end_ptr number;
544: token_val pay_payroll_actions.legislative_parameters%type;
545: par_value pay_payroll_actions.legislative_parameters%type;
546: BEGIN
547: --
548: token_val := name||'=';

Line 545: par_value pay_payroll_actions.legislative_parameters%type;

541: RETURN varchar2 IS
542: start_ptr number;
543: end_ptr number;
544: token_val pay_payroll_actions.legislative_parameters%type;
545: par_value pay_payroll_actions.legislative_parameters%type;
546: BEGIN
547: --
548: token_val := name||'=';
549: --

Line 906: l_legislative_param pay_payroll_actions.legislative_parameters%type;

902: l_year_start DATE;
903: l_year_end DATE;
904: l_report_type VARCHAR2(5);
905: l_business_grpid NUMBER;
906: l_legislative_param pay_payroll_actions.legislative_parameters%type;
907: /* Bug 4777374 Fix */
908: l_Informatique_tag CHAR(1);
909: l_Comptabilite_tag CHAR(1);
910: /* Bug 4906963 Fix */

Line 1487: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;

1483: l_rl2pap_asg_actid pay_assignment_actions.assignment_action_id%TYPE;
1484: l_rl2pap_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1485: l_transfer_pay_actid NUMBER;
1486: l_business_group_id NUMBER;
1487: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
1488: l_xml_blob BLOB;
1489:
1490: ----------------------------------------------------------------
1491: CURSOR c_get_report_type(p_payactid NUMBER) IS

Line 1497: pay_payroll_actions ppa

1493: ppa.report_type,
1494: ppa.business_group_id,
1495: ppa.legislative_parameters
1496: FROM
1497: pay_payroll_actions ppa
1498: WHERE
1499: ppa.payroll_action_id = p_payactid;
1500: ----------------------------------------------------------------
1501: CURSOR cur_parameters(p_mag_asg_action_id NUMBER) IS

Line 1510: pay_payroll_actions ppa,

1506: -- date_earned
1507: FROM
1508: pay_action_interlocks pai,
1509: pay_assignment_actions paa,
1510: pay_payroll_actions ppa,
1511: per_all_people_f ppf,
1512: per_all_assignments_f paf,
1513: pay_action_information pact
1514: WHERE paa.assignment_action_id = pai.locking_action_id

Line 1649: from pay_payroll_actions ppa,

1645:
1646: CURSOR c_get_payroll_asg_actid IS
1647: select ppa.payroll_action_id,
1648: ppa.business_group_id
1649: from pay_payroll_actions ppa,
1650: pay_assignment_actions paa
1651: where paa.assignment_action_id = p_arch_action_id
1652: and paa.payroll_action_id = ppa.payroll_action_id;
1653:

Line 4743: l_legislative_param pay_payroll_actions.legislative_parameters%type;

4739: l_year_start DATE;
4740: l_year_end DATE;
4741: l_report_type VARCHAR2(5);
4742: l_business_grpid NUMBER;
4743: l_legislative_param pay_payroll_actions.legislative_parameters%type;
4744: EOL varchar2(5);
4745: l_employer_name varchar2(100);
4746: l_quebec_bn varchar2(20);
4747: l_address_line per_addresses.address_line1%TYPE;

Line 5290: FROM pay_payroll_actions

5286: PROCEDURE archive_ca_deinit (p_pactid IN NUMBER) IS
5287:
5288: CURSOR c_get_report_type ( p_pactid number) IS
5289: SELECT report_type
5290: FROM pay_payroll_actions
5291: WHERE payroll_action_id = p_pactid;
5292:
5293: l_report_type pay_payroll_actions.report_type%type;
5294:

Line 5293: l_report_type pay_payroll_actions.report_type%type;

5289: SELECT report_type
5290: FROM pay_payroll_actions
5291: WHERE payroll_action_id = p_pactid;
5292:
5293: l_report_type pay_payroll_actions.report_type%type;
5294:
5295: BEGIN
5296:
5297: open c_get_report_type(p_pactid);