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 191: FROM pay_payroll_actions ppa

187: INTO p_year_start,
188: p_year_end,
189: p_business_group_id,
190: p_report_type
191: FROM pay_payroll_actions ppa
192: WHERE payroll_action_id = p_pactid;
193:
194: hr_utility.set_location('pay_ca_rl1_mag.get_report_parameters', 20);
195:

Line 283: pay_payroll_actions ppa

279: CURSOR cur_arch_pactid(p_transmitter_org_id NUMBER) IS
280: SELECT
281: ppa.payroll_action_id
282: FROM
283: pay_payroll_actions ppa
284: WHERE
285: ppa.business_group_id = p_bg_id AND
286: ppa.report_type = 'RL1' AND
287: ppa.report_qualifier = 'CAEOYRL1' AND

Line 302: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

298: dummy NUMBER;
299: dummy1 VARCHAR2(10);
300: l_transmitter_org_id NUMBER;
301: l_arch_pactid NUMBER;
302: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
303: l_address_line1 hr_locations.address_line_1%TYPE;
304:
305: CURSOR cur_ppa IS
306: SELECT

Line 309: pay_payroll_actions ppa

305: CURSOR cur_ppa IS
306: SELECT
307: ppa.legislative_parameters
308: FROM
309: pay_payroll_actions ppa
310: WHERE
311: ppa.payroll_action_id = p_payroll_action_id;
312:
313: BEGIN

Line 432: pay_payroll_actions ppa,

428: ff_database_items fdi1,
429: ff_archive_items fai2,
430: ff_database_items fdi2,
431: pay_assignment_actions paa,
432: pay_payroll_actions ppa,
433: pay_payroll_actions ppa1,
434: hr_organization_information hoi
435: where ppa1.payroll_action_id = :payroll_action_id
436: and ppa.business_group_id+0 = ppa1.business_group_id

Line 433: pay_payroll_actions ppa1,

429: ff_archive_items fai2,
430: ff_database_items fdi2,
431: pay_assignment_actions paa,
432: pay_payroll_actions ppa,
433: pay_payroll_actions ppa1,
434: hr_organization_information hoi
435: where ppa1.payroll_action_id = :payroll_action_id
436: and ppa.business_group_id+0 = ppa1.business_group_id
437: and ppa.effective_date = ppa1.effective_date

Line 492: FROM pay_payroll_actions ppa,

488: paa.tax_unit_id,
489: paf.effective_end_date,
490: paa.assignment_action_id,
491: ppa.payroll_action_id -- Added by ssmukher for Bug 3353115
492: FROM pay_payroll_actions ppa,
493: pay_assignment_actions paa,
494: per_all_assignments_f paf,
495: pay_payroll_actions ppa1,
496: hr_organization_information hoi

Line 495: pay_payroll_actions ppa1,

491: ppa.payroll_action_id -- Added by ssmukher for Bug 3353115
492: FROM pay_payroll_actions ppa,
493: pay_assignment_actions paa,
494: per_all_assignments_f paf,
495: pay_payroll_actions ppa1,
496: hr_organization_information hoi
497: WHERE ppa1.payroll_action_id = p_pactid
498: AND ppa.report_type = 'RL1'
499: AND ppa.business_group_id+0 = ppa1.business_group_id

Line 644: token_val pay_payroll_actions.legislative_parameters%type;

640:
641: function get_parameter(name in varchar2, parameter_list varchar2) return varchar2 is
642: start_ptr number;
643: end_ptr number;
644: token_val pay_payroll_actions.legislative_parameters%type;
645: par_value pay_payroll_actions.legislative_parameters%type;
646: begin
647: --
648: token_val := name||'=';

Line 645: par_value pay_payroll_actions.legislative_parameters%type;

641: function get_parameter(name in varchar2, parameter_list varchar2) return varchar2 is
642: start_ptr number;
643: end_ptr number;
644: token_val pay_payroll_actions.legislative_parameters%type;
645: par_value pay_payroll_actions.legislative_parameters%type;
646: begin
647: --
648: token_val := name||'=';
649: --

Line 1444: pay_payroll_actions ppa,

1440: per_all_people_f ppf,
1441: per_all_assignments_f paf,
1442: pay_action_interlocks pai,
1443: pay_assignment_actions paa,
1444: pay_payroll_actions ppa,
1445: pay_assignment_actions paa_arch
1446: WHERE
1447: paa.assignment_action_id = p_mag_asg_action_id AND
1448: ppa.payroll_action_id = paa.payroll_action_id AND

Line 1478: from pay_payroll_actions ppa

1474: := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1475: hr_utility.trace('l_payroll_actid='||l_payroll_actid);
1476: SELECT ppa.report_type
1477: INTO l_rep_type
1478: from pay_payroll_actions ppa
1479: where payroll_action_id=l_payroll_actid;
1480: hr_utility.trace('report_type='||l_rep_type);
1481: /******************************* ************************************/
1482: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value

Line 4794: FROM pay_payroll_actions

4790: PROCEDURE archive_ca_deinit (p_pactid IN NUMBER) IS
4791:
4792: CURSOR c_get_report_type ( p_pactid number) IS
4793: SELECT report_type
4794: FROM pay_payroll_actions
4795: WHERE payroll_action_id = p_pactid;
4796:
4797: l_report_type pay_payroll_actions.report_type%type;
4798:

Line 4797: l_report_type pay_payroll_actions.report_type%type;

4793: SELECT report_type
4794: FROM pay_payroll_actions
4795: WHERE payroll_action_id = p_pactid;
4796:
4797: l_report_type pay_payroll_actions.report_type%type;
4798:
4799: BEGIN
4800:
4801: open c_get_report_type(p_pactid);