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_AMEND_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 314: pay_assignment_actions paa_arch,

310: hr_utility.set_location( 'pay_ca_rl2_amend_mag.range_cursor', 20);
311: p_sqlstr := 'select distinct to_number(emp.person_id)
312: from pay_ca_eoy_rl2_employee_info_v emp,
313: pay_ca_eoy_rl2_trans_info_v tran,
314: pay_assignment_actions paa_arch,
315: pay_payroll_actions ppa_arch,
316: pay_payroll_actions ppa_mag,
317: hr_organization_information hoi
318: where ppa_mag.payroll_action_id = :payroll_action_id

Line 378: pay_assignment_actions paa_arch,

374: paf.effective_end_date,
375: max(paa_arch.assignment_action_id),
376: max(ppa_arch.payroll_action_id)
377: FROM pay_payroll_actions ppa_arch,
378: pay_assignment_actions paa_arch,
379: per_all_assignments_f paf,
380: hr_organization_information hoi
381: WHERE ppa_arch.report_type = 'CAEOY_RL2_AMEND_PP'
382: AND ppa_arch.business_group_id+0 = p_business_grpid

Line 403: pay_assignment_actions passt

399: AND not exists
400: ( SELECT pail.locked_action_id
401: FROM pay_action_interlocks pail,
402: pay_payroll_actions pact,
403: pay_assignment_actions passt
404: WHERE pact.report_type = 'RL2_AMEND_MAG'
405: AND pact.payroll_action_id = passt.payroll_action_id
406: AND passt.assignment_action_id = pail.locking_action_id
407: AND pail.locked_action_id = paa_arch.assignment_action_id)

Line 412: pay_assignment_actions passt

408: AND not exists
409: ( SELECT pail.locked_action_id
410: FROM pay_action_interlocks pail,
411: pay_payroll_actions pact,
412: pay_assignment_actions passt
413: WHERE pact.report_type = 'RL2_XML_MAG'
414: AND pact.payroll_action_id = passt.payroll_action_id
415: AND passt.assignment_action_id = pail.locking_action_id
416: AND pail.locked_action_id = paa_arch.assignment_action_id)

Line 421: pay_assignment_actions passt

417: AND not exists
418: ( SELECT pail.locked_action_id
419: FROM pay_action_interlocks pail,
420: pay_payroll_actions pact,
421: pay_assignment_actions passt
422: WHERE pact.report_type = 'CAEOY_RL2_AMEND_PP'
423: AND pact.payroll_action_id = passt.payroll_action_id
424: AND passt.assignment_action_id = pail.locking_action_id
425: AND pail.locked_action_id = paa_arch.assignment_action_id)

Line 442: pay_assignment_actions paa

438: paa.assignment_action_id,
439: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
440: ppa.legislative_parameters)
441: from pay_payroll_actions ppa,
442: pay_assignment_actions paa
443: where paa.serial_number = to_char(cp_person_id)
444: /* and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
445: ppa.legislative_parameters) =
446: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

Line 462: pay_assignment_actions passt

458: AND not exists
459: ( SELECT pail.locked_action_id
460: FROM pay_action_interlocks pail,
461: pay_payroll_actions pact,
462: pay_assignment_actions passt
463: WHERE pact.report_type = 'RL2_AMEND_MAG'
464: AND pact.payroll_action_id = passt.payroll_action_id
465: AND passt.assignment_action_id = pail.locking_action_id
466: AND passt.serial_number=to_char(cp_person_id)

Line 515: pay_assignment_actions where

511: AND payroll_action_id = p_pact_id;
512:
513: CURSOR c_paa_update_check (cp_locking_asg_act_id number) IS
514: select assignment_action_id from
515: pay_assignment_actions where
516: assignment_action_id = cp_locking_asg_act_id;
517:
518: l_year_start DATE;
519: l_year_end DATE;

Line 541: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

537: l_legislative_param pay_payroll_actions.legislative_parameters%type;
538:
539: ln_primary_assignment_id NUMBER := 0;
540: lv_report_type pay_payroll_actions.report_type%TYPE ;
541: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
542: ln_pre_id_null number;
543: ln_iteration number := 0;
544: lv_flag_count number := 0;
545: lv_employee_number per_people_f.employee_number%type;

Line 551: ln_serial_number pay_assignment_actions.serial_number%TYPE;

547: lv_full_name per_people_f.full_name%type;
548: lv_record_name varchar2(100);
549: lv_prov_of_emp varchar2(10);
550: lv_prov_amend_flag varchar2(5);
551: ln_serial_number pay_assignment_actions.serial_number%TYPE;
552: l_paa_update_check pay_assignment_actions.assignment_action_id%TYPE;
553:
554: BEGIN
555:

Line 552: l_paa_update_check pay_assignment_actions.assignment_action_id%TYPE;

548: lv_record_name varchar2(100);
549: lv_prov_of_emp varchar2(10);
550: lv_prov_amend_flag varchar2(5);
551: ln_serial_number pay_assignment_actions.serial_number%TYPE;
552: l_paa_update_check pay_assignment_actions.assignment_action_id%TYPE;
553:
554: BEGIN
555:
556:

Line 648: select pay_assignment_actions_s.nextval

644: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignment_act', 40);
645:
646: /* Create an assignment action for this person */
647:
648: select pay_assignment_actions_s.nextval
649: into lockingactid
650: from dual;
651: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 50);
652: hr_utility.trace('New RL2 Amend Action = ' ||

Line 709: /* Insert into pay_assignment_actions. */

705: if c_get_prov_amend_flag%FOUND then
706: --To make sure that only the latest amendment details are printed
707: if lv_prov_amend_flag = 'Y' AND lv_flag_count = 0 then
708:
709: /* Insert into pay_assignment_actions. */
710: hr_nonrun_asact.insact(lockingactid
711: ,ln_primary_assignment_id
712: ,p_pactid
713: ,p_chunk

Line 722: update pay_assignment_actions aa

718: ** Archiver assignment_action and Archiver Payroll_action_id
719: ** so that we need not refer back in the reports.
720: ***********************************************************/
721:
722: update pay_assignment_actions aa
723: set aa.serial_number = to_char(l_person_id)
724: where aa.assignment_action_id = lockingactid;
725:
726: --Added to lock the Amend Archiver

Line 759: update pay_assignment_actions aa

755: ** Archiver assignment_action and Archiver Payroll_action_id
756: ** so that we need not refer back in the reports.
757: ***********************************************************/
758:
759: update pay_assignment_actions aa
760: set aa.serial_number = to_char(l_person_id)
761: where aa.assignment_action_id = lockingactid;
762:
763: --Added to lock the previous mag Reports

Line 1329: pay_assignment_actions paa

1325: to_number(substr(paa.serial_number,3,14)) payactid,
1326: to_number(substr(paa.serial_number,17,14)) asgactid,
1327: paa.assignment_id asgid
1328: FROM
1329: pay_assignment_actions paa
1330: WHERE paa.assignment_action_id = p_payactid;
1331:
1332: CURSOR c_get_report_type(p_payactid NUMBER) IS
1333: SELECT

Line 1369: pay_assignment_actions paa,

1365: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1366: -- date_earned
1367: FROM
1368: pay_action_interlocks pai,
1369: pay_assignment_actions paa,
1370: pay_payroll_actions ppa,
1371: per_all_people_f ppf,
1372: per_all_assignments_f paf,
1373: pay_action_information pact

Line 1496: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

1492: l_rl2_box_o varchar2(240);
1493: l_rl2_source_of_income varchar2(240);
1494: l_negative_balance_flag varchar2(240);
1495:
1496: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1497: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1498: l_asg_id per_assignments_f.assignment_id%TYPE;
1499: l_date_earned DATE;
1500: l_province VARCHAR2(30);

Line 1497: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;

1493: l_rl2_source_of_income varchar2(240);
1494: l_negative_balance_flag varchar2(240);
1495:
1496: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1497: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1498: l_asg_id per_assignments_f.assignment_id%TYPE;
1499: l_date_earned DATE;
1500: l_province VARCHAR2(30);
1501: