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 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_mag.get_report_parameters', 20);
50:

Line 73: pay_payroll_actions ppa

69: CURSOR cur_arch_pactid(p_transmitter_org_id NUMBER) 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 = 'RL2' AND
77: ppa.report_qualifier = 'CAEOYRL2' AND

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: CURSOR cur_ppa IS
96: SELECT

Line 99: pay_payroll_actions ppa

95: CURSOR cur_ppa IS
96: SELECT
97: ppa.legislative_parameters
98: FROM
99: pay_payroll_actions ppa
100: WHERE
101: ppa.payroll_action_id = p_payroll_action_id;
102:
103: BEGIN

Line 210: p_legislative_param pay_payroll_actions.legislative_parameters%type;

206: p_year_start DATE;
207: p_year_end DATE;
208: p_business_group_id NUMBER;
209: p_report_type VARCHAR2(30);
210: p_legislative_param pay_payroll_actions.legislative_parameters%type;
211:
212: BEGIN
213:
214: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor', 10);

Line 231: pay_payroll_actions ppa_arch,

227: p_sqlstr := 'select distinct to_number(emp.person_id)
228: from pay_ca_eoy_rl2_employee_info_v emp,
229: pay_ca_eoy_rl2_trans_info_v tran,
230: pay_assignment_actions paa_arch,
231: pay_payroll_actions ppa_arch,
232: pay_payroll_actions ppa_mag,
233: hr_organization_information hoi
234: where ppa_mag.payroll_action_id = :payroll_action_id
235: and ppa_arch.business_group_id+0 = ppa_mag.business_group_id

Line 232: pay_payroll_actions ppa_mag,

228: from pay_ca_eoy_rl2_employee_info_v emp,
229: pay_ca_eoy_rl2_trans_info_v tran,
230: pay_assignment_actions paa_arch,
231: pay_payroll_actions ppa_arch,
232: pay_payroll_actions ppa_mag,
233: hr_organization_information hoi
234: where ppa_mag.payroll_action_id = :payroll_action_id
235: and ppa_arch.business_group_id+0 = ppa_mag.business_group_id
236: and ppa_arch.effective_date = ppa_mag.effective_date

Line 293: FROM pay_payroll_actions ppa_arch,

289: paa_arch.tax_unit_id,
290: paf.effective_end_date,
291: paa_arch.assignment_action_id,
292: ppa_arch.payroll_action_id
293: FROM pay_payroll_actions ppa_arch,
294: pay_assignment_actions paa_arch,
295: per_all_assignments_f paf,
296: hr_organization_information hoi
297: WHERE ppa_arch.report_type = 'RL2'

Line 336: l_legislative_param pay_payroll_actions.legislative_parameters%type;

332: l_quebec_no VARCHAR2(20);
333: l_file_no VARCHAR2(10);
334: l_return NUMBER;
335: l_addr_line VARCHAR2(240);
336: l_legislative_param pay_payroll_actions.legislative_parameters%type;
337:
338: BEGIN
339:
340: -- hr_utility.trace_on(NULL,'RL2MAG');

Line 461: token_val pay_payroll_actions.legislative_parameters%type;

457: FUNCTION get_parameter(name IN varchar2, parameter_list varchar2)
458: RETURN varchar2 IS
459: start_ptr number;
460: end_ptr number;
461: token_val pay_payroll_actions.legislative_parameters%type;
462: par_value pay_payroll_actions.legislative_parameters%type;
463: BEGIN
464: --
465: token_val := name||'=';

Line 462: par_value pay_payroll_actions.legislative_parameters%type;

458: RETURN varchar2 IS
459: start_ptr number;
460: end_ptr number;
461: token_val pay_payroll_actions.legislative_parameters%type;
462: par_value pay_payroll_actions.legislative_parameters%type;
463: BEGIN
464: --
465: token_val := name||'=';
466: --

Line 795: l_legislative_param pay_payroll_actions.legislative_parameters%type;

791: l_year_start DATE;
792: l_year_end DATE;
793: l_report_type VARCHAR2(5);
794: l_business_grpid NUMBER;
795: l_legislative_param pay_payroll_actions.legislative_parameters%type;
796: /* Bug 4777374 Fix */
797: l_Informatique_tag CHAR(1);
798: l_Comptabilite_tag CHAR(1);
799: /* Bug 4906963 Fix */

Line 1182: pay_payroll_actions ppa

1178: ppa.report_type,
1179: ppa.business_group_id,
1180: ppa.legislative_parameters
1181: FROM
1182: pay_payroll_actions ppa
1183: WHERE
1184: ppa.payroll_action_id = p_payactid;
1185:
1186: CURSOR c_get_employer_info(p_pact_id NUMBER,

Line 1213: pay_payroll_actions ppa,

1209: -- date_earned
1210: FROM
1211: pay_action_interlocks pai,
1212: pay_assignment_actions paa,
1213: pay_payroll_actions ppa,
1214: per_all_people_f ppf,
1215: per_all_assignments_f paf,
1216: pay_action_information pact
1217: WHERE paa.assignment_action_id = pai.locking_action_id

Line 1454: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;

1450: l_footcode VARCHAR2(100);
1451: l_footamt NUMBER;
1452: l_footnotecode NUMBER;
1453: l_footnoteamt NUMBER;
1454: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
1455:
1456: l_authorisation_no NUMBER;
1457: l_authorisation_tag NUMBER;
1458: l_sequence_no NUMBER;

Line 3119: l_legislative_param pay_payroll_actions.legislative_parameters%type;

3115: l_year_start DATE;
3116: l_year_end DATE;
3117: l_report_type VARCHAR2(5);
3118: l_business_grpid NUMBER;
3119: l_legislative_param pay_payroll_actions.legislative_parameters%type;
3120: EOL varchar2(5);
3121: l_employer_name varchar2(100);
3122: l_quebec_bn varchar2(20);
3123: l_address_line per_addresses.address_line1%TYPE;

Line 3666: FROM pay_payroll_actions

3662: PROCEDURE archive_ca_deinit (p_pactid IN NUMBER) IS
3663:
3664: CURSOR c_get_report_type ( p_pactid number) IS
3665: SELECT report_type
3666: FROM pay_payroll_actions
3667: WHERE payroll_action_id = p_pactid;
3668:
3669: l_report_type pay_payroll_actions.report_type%type;
3670:

Line 3669: l_report_type pay_payroll_actions.report_type%type;

3665: SELECT report_type
3666: FROM pay_payroll_actions
3667: WHERE payroll_action_id = p_pactid;
3668:
3669: l_report_type pay_payroll_actions.report_type%type;
3670:
3671: BEGIN
3672:
3673: open c_get_report_type(p_pactid);