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

Line 46: FROM pay_payroll_actions ppa

42: p_year_end,
43: p_business_group_id,
44: p_report_type,
45: p_legislative_param
46: FROM pay_payroll_actions ppa
47: WHERE payroll_action_id = p_pactid;
48:
49: hr_utility.set_location('pay_ca_rl2_can_mag.get_report_parameters', 20);
50:

Line 73: pay_payroll_actions ppa

69: CURSOR cur_arch_pactid(p_transmitter_org_id NUMBER,p_report_type VARCHAR2) IS
70: SELECT
71: ppa.payroll_action_id
72: FROM
73: pay_payroll_actions ppa
74: WHERE
75: ppa.business_group_id = p_bg_id AND
76: ppa.report_type = decode(p_report_type,
77: 'RL2_XML_MAG', 'RL2',

Line 92: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

88: dummy NUMBER;
89: dummy1 VARCHAR2(10);
90: l_transmitter_org_id NUMBER;
91: l_arch_pactid NUMBER;
92: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
93: l_address_line1 per_addresses.address_line1%TYPE;
94:
95: l_locked_report_type pay_payroll_actions.report_type%TYPE;
96: l_mag_pactid NUMBER;

Line 95: l_locked_report_type pay_payroll_actions.report_type%TYPE;

91: l_arch_pactid NUMBER;
92: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
93: l_address_line1 per_addresses.address_line1%TYPE;
94:
95: l_locked_report_type pay_payroll_actions.report_type%TYPE;
96: l_mag_pactid NUMBER;
97:
98: CURSOR cur_ppa IS
99: SELECT

Line 102: pay_payroll_actions ppa

98: CURSOR cur_ppa IS
99: SELECT
100: ppa.legislative_parameters
101: FROM
102: pay_payroll_actions ppa
103: WHERE
104: ppa.payroll_action_id = p_payroll_action_id;
105:
106: CURSOR c_ppa_report_type(p_pact_id number) IS

Line 110: pay_payroll_actions ppa

106: CURSOR c_ppa_report_type(p_pact_id number) IS
107: SELECT
108: ppa.report_type
109: FROM
110: pay_payroll_actions ppa
111: WHERE
112: ppa.payroll_action_id = p_pact_id;
113:
114: BEGIN

Line 231: p_legislative_param pay_payroll_actions.legislative_parameters%type;

227: p_year_start DATE;
228: p_year_end DATE;
229: p_business_group_id NUMBER;
230: p_report_type VARCHAR2(30);
231: p_legislative_param pay_payroll_actions.legislative_parameters%type;
232:
233: BEGIN
234:
235: hr_utility.set_location( 'pay_ca_rl2_can_mag.range_cursor', 10);

Line 250: pay_payroll_actions ppa,

246: hr_utility.set_location( 'pay_ca_rl2_can_mag.range_cursor', 20);
247:
248: p_sqlstr := 'select distinct paaf.person_id
249: from per_all_assignments_f paaf,
250: pay_payroll_actions ppa,
251: pay_payroll_actions ppa1,
252: pay_assignment_actions paa
253: where ppa.payroll_action_id = paa.payroll_action_id
254: and paa.assignment_id = paaf.assignment_id

Line 251: pay_payroll_actions ppa1,

247:
248: p_sqlstr := 'select distinct paaf.person_id
249: from per_all_assignments_f paaf,
250: pay_payroll_actions ppa,
251: pay_payroll_actions ppa1,
252: pay_assignment_actions paa
253: where ppa.payroll_action_id = paa.payroll_action_id
254: and paa.assignment_id = paaf.assignment_id
255: and ppa1.payroll_action_id = :payroll_action_id

Line 303: pay_payroll_actions ppa,

299: paa.assignment_action_id,
300: ppa2.payroll_action_id
301: from
302: per_all_assignments_f paaf,
303: pay_payroll_actions ppa,
304: pay_payroll_actions ppa1,
305: pay_payroll_actions ppa2,
306: pay_assignment_actions paa,
307: pay_assignment_actions paa1,

Line 304: pay_payroll_actions ppa1,

300: ppa2.payroll_action_id
301: from
302: per_all_assignments_f paaf,
303: pay_payroll_actions ppa,
304: pay_payroll_actions ppa1,
305: pay_payroll_actions ppa2,
306: pay_assignment_actions paa,
307: pay_assignment_actions paa1,
308: pay_action_interlocks int

Line 305: pay_payroll_actions ppa2,

301: from
302: per_all_assignments_f paaf,
303: pay_payroll_actions ppa,
304: pay_payroll_actions ppa1,
305: pay_payroll_actions ppa2,
306: pay_assignment_actions paa,
307: pay_assignment_actions paa1,
308: pay_action_interlocks int
309: where

Line 343: pay_payroll_actions ppa,

339: paa.assignment_action_id,
340: ppa2.payroll_action_id
341: from
342: per_all_assignments_f paaf,
343: pay_payroll_actions ppa,
344: pay_payroll_actions ppa1,
345: pay_payroll_actions ppa2,
346: pay_assignment_actions paa,
347: pay_assignment_actions paa1,

Line 344: pay_payroll_actions ppa1,

340: ppa2.payroll_action_id
341: from
342: per_all_assignments_f paaf,
343: pay_payroll_actions ppa,
344: pay_payroll_actions ppa1,
345: pay_payroll_actions ppa2,
346: pay_assignment_actions paa,
347: pay_assignment_actions paa1,
348: pay_action_interlocks int

Line 345: pay_payroll_actions ppa2,

341: from
342: per_all_assignments_f paaf,
343: pay_payroll_actions ppa,
344: pay_payroll_actions ppa1,
345: pay_payroll_actions ppa2,
346: pay_assignment_actions paa,
347: pay_assignment_actions paa1,
348: pay_action_interlocks int
349: where

Line 401: l_legislative_param pay_payroll_actions.legislative_parameters%type;

397: l_quebec_no VARCHAR2(20);
398: l_file_no VARCHAR2(10);
399: l_return NUMBER;
400: l_addr_line VARCHAR2(240);
401: l_legislative_param pay_payroll_actions.legislative_parameters%type;
402:
403: BEGIN
404:
405: -- hr_utility.trace_on(NULL,'RL2MAG');

Line 547: token_val pay_payroll_actions.legislative_parameters%type;

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

Line 548: par_value pay_payroll_actions.legislative_parameters%type;

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

Line 887: l_legislative_param pay_payroll_actions.legislative_parameters%type;

883: l_year_start DATE;
884: l_year_end DATE;
885: l_report_type VARCHAR2(30);
886: l_business_grpid NUMBER;
887: l_legislative_param pay_payroll_actions.legislative_parameters%type;
888: /* Bug 4777374 Fix */
889: l_Informatique_tag CHAR(1);
890: l_Comptabilite_tag CHAR(1);
891: /* Bug 4906963 Fix */

Line 1337: pay_payroll_actions ppa

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

Line 1384: pay_payroll_actions ppa,

1380: per_all_people_f ppf,
1381: per_all_assignments_f paf,
1382: pay_action_interlocks pai_mag,
1383: pay_action_interlocks pai_arch,
1384: pay_payroll_actions ppa,
1385: pay_payroll_actions ppa_arch,
1386: pay_assignment_actions paa_mag,
1387: pay_assignment_actions paa_arch,
1388: pay_action_information pact

Line 1385: pay_payroll_actions ppa_arch,

1381: per_all_assignments_f paf,
1382: pay_action_interlocks pai_mag,
1383: pay_action_interlocks pai_arch,
1384: pay_payroll_actions ppa,
1385: pay_payroll_actions ppa_arch,
1386: pay_assignment_actions paa_mag,
1387: pay_assignment_actions paa_arch,
1388: pay_action_information pact
1389: WHERE

Line 1655: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;

1651: l_footcode VARCHAR2(100);
1652: l_footamt NUMBER;
1653: l_footnotecode NUMBER;
1654: l_footnoteamt NUMBER;
1655: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
1656:
1657: BEGIN
1658:
1659: hr_utility.trace('XML Employee');

Line 2708: l_legislative_param pay_payroll_actions.legislative_parameters%type;

2704: l_year_start DATE;
2705: l_year_end DATE;
2706: l_report_type VARCHAR2(30);
2707: l_business_grpid NUMBER;
2708: l_legislative_param pay_payroll_actions.legislative_parameters%type;
2709: EOL varchar2(5);
2710: l_employer_name varchar2(100);
2711: l_quebec_bn varchar2(20);
2712: l_address_line per_addresses.address_line1%TYPE;