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

Line 43: FROM pay_payroll_actions ppa

39: INTO p_year_start,
40: p_year_end,
41: p_business_group_id,
42: p_report_type
43: FROM pay_payroll_actions ppa
44: WHERE payroll_action_id = p_pactid;
45:
46: hr_utility.set_location('pay_ca_rl1_mag.get_report_parameters', 20);
47:

Line 135: pay_payroll_actions ppa

131: CURSOR cur_arch_pactid(p_transmitter_org_id NUMBER) IS
132: SELECT
133: ppa.payroll_action_id
134: FROM
135: pay_payroll_actions ppa
136: WHERE
137: ppa.business_group_id = p_bg_id AND
138: ppa.report_type = 'RL1' AND
139: ppa.report_qualifier = 'CAEOYRL1' AND

Line 154: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

150: dummy NUMBER;
151: dummy1 VARCHAR2(10);
152: l_transmitter_org_id NUMBER;
153: l_arch_pactid NUMBER;
154: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
155: l_address_line1 hr_locations.address_line_1%TYPE;
156:
157: CURSOR cur_ppa IS
158: SELECT

Line 161: pay_payroll_actions ppa

157: CURSOR cur_ppa IS
158: SELECT
159: ppa.legislative_parameters
160: FROM
161: pay_payroll_actions ppa
162: WHERE
163: ppa.payroll_action_id = p_payroll_action_id;
164:
165: BEGIN

Line 284: pay_payroll_actions ppa,

280: ff_database_items fdi1,
281: ff_archive_items fai2,
282: ff_database_items fdi2,
283: pay_assignment_actions paa,
284: pay_payroll_actions ppa,
285: pay_payroll_actions ppa1,
286: hr_organization_information hoi
287: where ppa1.payroll_action_id = :payroll_action_id
288: and ppa.business_group_id+0 = ppa1.business_group_id

Line 285: pay_payroll_actions ppa1,

281: ff_archive_items fai2,
282: ff_database_items fdi2,
283: pay_assignment_actions paa,
284: pay_payroll_actions ppa,
285: pay_payroll_actions ppa1,
286: hr_organization_information hoi
287: where ppa1.payroll_action_id = :payroll_action_id
288: and ppa.business_group_id+0 = ppa1.business_group_id
289: and ppa.effective_date = ppa1.effective_date

Line 344: FROM pay_payroll_actions ppa,

340: paa.tax_unit_id,
341: paf.effective_end_date,
342: paa.assignment_action_id,
343: ppa.payroll_action_id -- Added by ssmukher for Bug 3353115
344: FROM pay_payroll_actions ppa,
345: pay_assignment_actions paa,
346: per_all_assignments_f paf,
347: pay_payroll_actions ppa1,
348: hr_organization_information hoi

Line 347: pay_payroll_actions ppa1,

343: ppa.payroll_action_id -- Added by ssmukher for Bug 3353115
344: FROM pay_payroll_actions ppa,
345: pay_assignment_actions paa,
346: per_all_assignments_f paf,
347: pay_payroll_actions ppa1,
348: hr_organization_information hoi
349: WHERE ppa1.payroll_action_id = p_pactid
350: AND ppa.report_type = 'RL1'
351: AND ppa.business_group_id+0 = ppa1.business_group_id

Line 486: token_val pay_payroll_actions.legislative_parameters%type;

482:
483: function get_parameter(name in varchar2, parameter_list varchar2) return varchar2 is
484: start_ptr number;
485: end_ptr number;
486: token_val pay_payroll_actions.legislative_parameters%type;
487: par_value pay_payroll_actions.legislative_parameters%type;
488: begin
489: --
490: token_val := name||'=';

Line 487: par_value pay_payroll_actions.legislative_parameters%type;

483: function get_parameter(name in varchar2, parameter_list varchar2) return varchar2 is
484: start_ptr number;
485: end_ptr number;
486: token_val pay_payroll_actions.legislative_parameters%type;
487: par_value pay_payroll_actions.legislative_parameters%type;
488: begin
489: --
490: token_val := name||'=';
491: --

Line 1015: l_legislative_param pay_payroll_actions.legislative_parameters%type;

1011: l_rep_type VARCHAR2(30);
1012: l_business_group_id NUMBER;
1013: l_year_start DATE;
1014: l_year_end DATE;
1015: l_legislative_param pay_payroll_actions.legislative_parameters%type;
1016: l_arch_asg_actid NUMBER;
1017: l_arch_pay_actid NUMBER;
1018: -- l_asg_id NUMBER;
1019: l_emplyr_final1 VARCHAR2(5000);

Line 1077: pay_payroll_actions ppa,

1073: per_all_people_f ppf,
1074: per_all_assignments_f paf,
1075: pay_action_interlocks pai,
1076: pay_assignment_actions paa,
1077: pay_payroll_actions ppa,
1078: pay_assignment_actions paa_arch
1079: WHERE
1080: paa.assignment_action_id = p_mag_asg_action_id AND
1081: ppa.payroll_action_id = paa.payroll_action_id AND

Line 1265: from pay_payroll_actions ppa

1261: := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1262: hr_utility.trace('l_payroll_actid='||l_payroll_actid);
1263: SELECT ppa.report_type
1264: INTO l_rep_type
1265: from pay_payroll_actions ppa
1266: where payroll_action_id=l_payroll_actid;
1267: hr_utility.trace('report_type='||l_rep_type);
1268: /******************************* ************************************/
1269:

Line 4733: FROM pay_payroll_actions

4729: PROCEDURE archive_ca_deinit (p_pactid IN NUMBER) IS
4730:
4731: CURSOR c_get_report_type ( p_pactid number) IS
4732: SELECT report_type
4733: FROM pay_payroll_actions
4734: WHERE payroll_action_id = p_pactid;
4735:
4736: l_report_type pay_payroll_actions.report_type%type;
4737:

Line 4736: l_report_type pay_payroll_actions.report_type%type;

4732: SELECT report_type
4733: FROM pay_payroll_actions
4734: WHERE payroll_action_id = p_pactid;
4735:
4736: l_report_type pay_payroll_actions.report_type%type;
4737:
4738: BEGIN
4739:
4740: open c_get_report_type(p_pactid);