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_RL1_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_parameters
46: FROM pay_payroll_actions ppa
47: WHERE payroll_action_id = p_pactid;
48:
49: hr_utility.set_location('pay_ca_rl1_can_mag.get_report_parameters', 20);
50:

Line 138: pay_payroll_actions ppa

134: CURSOR cur_arch_pactid(p_transmitter_org_id NUMBER, p_report_type VARCHAR2) IS
135: SELECT
136: ppa.payroll_action_id
137: FROM
138: pay_payroll_actions ppa
139: WHERE
140: ppa.business_group_id = p_bg_id AND
141: ppa.report_type = decode(p_report_type,
142: 'RL1_XML_MAG', 'RL1',

Line 157: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

153: dummy NUMBER;
154: dummy1 VARCHAR2(10);
155: l_transmitter_org_id NUMBER;
156: l_arch_pactid NUMBER;
157: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
158: l_address_line1 hr_locations.address_line_1%TYPE;
159: l_locked_report_type pay_payroll_actions.report_type%TYPE;
160: l_mag_pactid NUMBER;
161:

Line 159: l_locked_report_type pay_payroll_actions.report_type%TYPE;

155: l_transmitter_org_id NUMBER;
156: l_arch_pactid NUMBER;
157: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
158: l_address_line1 hr_locations.address_line_1%TYPE;
159: l_locked_report_type pay_payroll_actions.report_type%TYPE;
160: l_mag_pactid NUMBER;
161:
162: CURSOR cur_ppa IS
163: SELECT

Line 166: pay_payroll_actions ppa

162: CURSOR cur_ppa IS
163: SELECT
164: ppa.legislative_parameters
165: FROM
166: pay_payroll_actions ppa
167: WHERE
168: ppa.payroll_action_id = p_payroll_action_id;
169:
170: CURSOR c_ppa_report_type(p_pact_id number) IS

Line 174: pay_payroll_actions ppa

170: CURSOR c_ppa_report_type(p_pact_id number) IS
171: SELECT
172: ppa.report_type
173: FROM
174: pay_payroll_actions ppa
175: WHERE
176: ppa.payroll_action_id = p_pact_id;
177:
178: BEGIN

Line 392: pay_payroll_actions ppa,

388: hr_utility.set_location( 'pay_ca_rl1_can_mag.range_cursor', 10);
389:
390: p_sqlstr := 'select distinct paaf.person_id
391: from per_all_assignments_f paaf,
392: pay_payroll_actions ppa,
393: pay_payroll_actions ppa1,
394: pay_assignment_actions paa
395: where ppa.payroll_action_id = paa.payroll_action_id
396: and paa.assignment_id = paaf.assignment_id

Line 393: pay_payroll_actions ppa1,

389:
390: p_sqlstr := 'select distinct paaf.person_id
391: from per_all_assignments_f paaf,
392: pay_payroll_actions ppa,
393: pay_payroll_actions ppa1,
394: pay_assignment_actions paa
395: where ppa.payroll_action_id = paa.payroll_action_id
396: and paa.assignment_id = paaf.assignment_id
397: and ppa1.payroll_action_id = :payroll_action_id

Line 463: pay_payroll_actions ppa,

459: paa.assignment_action_id,
460: ppa2.payroll_action_id
461: from
462: per_all_assignments_f paaf,
463: pay_payroll_actions ppa,
464: pay_payroll_actions ppa1,
465: pay_payroll_actions ppa2,
466: pay_assignment_actions paa,
467: pay_assignment_actions paa1,

Line 464: pay_payroll_actions ppa1,

460: ppa2.payroll_action_id
461: from
462: per_all_assignments_f paaf,
463: pay_payroll_actions ppa,
464: pay_payroll_actions ppa1,
465: pay_payroll_actions ppa2,
466: pay_assignment_actions paa,
467: pay_assignment_actions paa1,
468: pay_action_interlocks int

Line 465: pay_payroll_actions ppa2,

461: from
462: per_all_assignments_f paaf,
463: pay_payroll_actions ppa,
464: pay_payroll_actions ppa1,
465: pay_payroll_actions ppa2,
466: pay_assignment_actions paa,
467: pay_assignment_actions paa1,
468: pay_action_interlocks int
469: where

Line 504: pay_payroll_actions ppa,

500: paa.assignment_action_id,
501: ppa2.payroll_action_id
502: from
503: per_all_assignments_f paaf,
504: pay_payroll_actions ppa,
505: pay_payroll_actions ppa1,
506: pay_payroll_actions ppa2,
507: pay_assignment_actions paa,
508: pay_assignment_actions paa1,

Line 505: pay_payroll_actions ppa1,

501: ppa2.payroll_action_id
502: from
503: per_all_assignments_f paaf,
504: pay_payroll_actions ppa,
505: pay_payroll_actions ppa1,
506: pay_payroll_actions ppa2,
507: pay_assignment_actions paa,
508: pay_assignment_actions paa1,
509: pay_action_interlocks int

Line 506: pay_payroll_actions ppa2,

502: from
503: per_all_assignments_f paaf,
504: pay_payroll_actions ppa,
505: pay_payroll_actions ppa1,
506: pay_payroll_actions ppa2,
507: pay_assignment_actions paa,
508: pay_assignment_actions paa1,
509: pay_action_interlocks int
510: where

Line 666: token_val pay_payroll_actions.legislative_parameters%type;

662:
663: function get_parameter(name in varchar2, parameter_list varchar2) return varchar2 is
664: start_ptr number;
665: end_ptr number;
666: token_val pay_payroll_actions.legislative_parameters%type;
667: par_value pay_payroll_actions.legislative_parameters%type;
668: begin
669: --
670: token_val := name||'=';

Line 667: par_value pay_payroll_actions.legislative_parameters%type;

663: function get_parameter(name in varchar2, parameter_list varchar2) return varchar2 is
664: start_ptr number;
665: end_ptr number;
666: token_val pay_payroll_actions.legislative_parameters%type;
667: par_value pay_payroll_actions.legislative_parameters%type;
668: begin
669: --
670: token_val := name||'=';
671: --

Line 1245: l_legislative_param pay_payroll_actions.legislative_parameters%type;

1241: l_rep_type VARCHAR2(30);
1242: l_business_group_id NUMBER;
1243: l_year_start DATE;
1244: l_year_end DATE;
1245: l_legislative_param pay_payroll_actions.legislative_parameters%type;
1246: l_arch_asg_actid NUMBER;
1247: l_arch_pay_actid NUMBER;
1248: -- l_asg_id NUMBER;
1249: l_emplyr_final1 VARCHAR2(5000);

Line 1355: pay_payroll_actions ppa,

1351: per_all_people_f ppf,
1352: per_all_assignments_f paf,
1353: pay_action_interlocks pai_mag,
1354: pay_action_interlocks pai_arch,
1355: pay_payroll_actions ppa,
1356: pay_payroll_actions ppa_arch,
1357: pay_assignment_actions paa_mag,
1358: pay_assignment_actions paa_arch
1359: WHERE

Line 1356: pay_payroll_actions ppa_arch,

1352: per_all_assignments_f paf,
1353: pay_action_interlocks pai_mag,
1354: pay_action_interlocks pai_arch,
1355: pay_payroll_actions ppa,
1356: pay_payroll_actions ppa_arch,
1357: pay_assignment_actions paa_mag,
1358: pay_assignment_actions paa_arch
1359: WHERE
1360: paa_mag.assignment_action_id = p_mag_asg_action_id AND

Line 1558: from pay_payroll_actions ppa

1554: hr_utility.trace('l_payroll_actid='||l_payroll_actid);
1555:
1556: SELECT ppa.report_type
1557: INTO l_rep_type
1558: from pay_payroll_actions ppa
1559: where payroll_action_id=l_payroll_actid;
1560: hr_utility.trace('report_type='||l_rep_type);
1561:
1562: hr_utility.trace('XML Employee');