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

Line 395: pay_assignment_actions paa,

391: from ff_archive_items fai1,
392: ff_database_items fdi1,
393: ff_archive_items fai2,
394: ff_database_items fdi2,
395: pay_assignment_actions paa,
396: pay_payroll_actions ppa,
397: pay_payroll_actions ppa1,
398: hr_organization_information hoi
399: where ppa1.payroll_action_id = :payroll_action_id

Line 457: pay_assignment_actions paa,

453: paf.effective_end_date,
454: max(paa.assignment_action_id),
455: max(ppa.payroll_action_id) -- Added by ssmukher for Bug 3353115
456: FROM pay_payroll_actions ppa,
457: pay_assignment_actions paa,
458: per_all_assignments_f paf,
459: pay_payroll_actions ppa1,
460: hr_organization_information hoi
461: WHERE ppa1.payroll_action_id = p_pactid

Line 484: pay_assignment_actions passt

480: AND not exists
481: ( SELECT pail.locked_action_id
482: FROM pay_action_interlocks pail,
483: pay_payroll_actions pact,
484: pay_assignment_actions passt
485: WHERE pact.report_type = 'RL1_AMEND_MAG'
486: AND pact.payroll_action_id = passt.payroll_action_id
487: AND passt.assignment_action_id = pail.locking_action_id
488: AND pail.locked_action_id = paa.assignment_action_id)

Line 494: pay_assignment_actions passt

490: AND not exists
491: ( SELECT pail.locked_action_id
492: FROM pay_action_interlocks pail,
493: pay_payroll_actions pact,
494: pay_assignment_actions passt
495: WHERE pact.report_type = 'RL1_XML_MAG'
496: AND pact.payroll_action_id = passt.payroll_action_id
497: AND passt.assignment_action_id = pail.locking_action_id
498: AND pail.locked_action_id = paa.assignment_action_id)

Line 504: pay_assignment_actions passt

500: AND not exists
501: ( SELECT pail.locked_action_id
502: FROM pay_action_interlocks pail,
503: pay_payroll_actions pact,
504: pay_assignment_actions passt
505: WHERE pact.report_type = 'CAEOY_RL1_AMEND_PP'
506: AND pact.payroll_action_id = passt.payroll_action_id
507: AND passt.assignment_action_id = pail.locking_action_id
508: AND pail.locked_action_id = paa.assignment_action_id)

Line 526: pay_assignment_actions paa,

522: paa.assignment_action_id,
523: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
524: ppa.legislative_parameters)
525: from pay_payroll_actions ppa,
526: pay_assignment_actions paa,
527: per_assignments_f paf
528: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
529: and paa.assignment_id = paf.assignment_id
530: /* and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

Line 548: pay_assignment_actions passt

544: AND not exists
545: ( SELECT pail.locked_action_id
546: FROM pay_action_interlocks pail,
547: pay_payroll_actions pact,
548: pay_assignment_actions passt
549: WHERE pact.report_type = 'RL1_AMEND_MAG'
550: AND pact.payroll_action_id = passt.payroll_action_id
551: AND passt.assignment_action_id = pail.locking_action_id
552: AND passt.serial_number=to_char(cp_person_id)

Line 602: pay_assignment_actions where

598: = to_char(cp_pre);
599:
600: CURSOR c_paa_update_check (cp_locking_asg_act_id number) IS
601: select assignment_action_id from
602: pay_assignment_actions where
603: assignment_action_id = cp_locking_asg_act_id;
604:
605: --local variables
606:

Line 630: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

626: l_return NUMBER;
627:
628: ln_primary_assignment_id NUMBER := 0;
629: lv_report_type pay_payroll_actions.report_type%TYPE ;
630: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
631: ln_pre_id_null number;
632: ln_iteration number := 0;
633: lv_flag_count number := 0;
634: lv_employee_number per_people_f.employee_number%type;

Line 641: ln_serial_number pay_assignment_actions.serial_number%TYPE;

637: lv_record_name varchar2(100);
638: ln_rl1_amend_flag_ue_id number;
639: lv_prov_of_emp varchar2(10);
640: lv_prov_amend_flag varchar2(5);
641: ln_serial_number pay_assignment_actions.serial_number%TYPE;
642: l_paa_update_check pay_assignment_actions.assignment_action_id%TYPE;
643:
644: BEGIN
645:

Line 642: l_paa_update_check pay_assignment_actions.assignment_action_id%TYPE;

638: ln_rl1_amend_flag_ue_id number;
639: lv_prov_of_emp varchar2(10);
640: lv_prov_amend_flag varchar2(5);
641: ln_serial_number pay_assignment_actions.serial_number%TYPE;
642: l_paa_update_check pay_assignment_actions.assignment_action_id%TYPE;
643:
644: BEGIN
645:
646: -- hr_utility.trace_on('Y','RL1MAG');

Line 719: select pay_assignment_actions_s.nextval

715:
716: /* Create an assignment action for this person */
717:
718:
719: select pay_assignment_actions_s.nextval
720: into lockingactid
721: from dual;
722: hr_utility.set_location('pay_ca_rl1_amend_mag.create_assignement_act', 50);
723: hr_utility.trace('New RL1 Amend Action = ' ||

Line 792: /* Insert into pay_assignment_actions. */

788: if c_get_prov_amend_flag%FOUND then
789: --To make sure only the latest amendment details are printed
790: if lv_prov_amend_flag = 'Y' AND lv_flag_count = 0 then
791:
792: /* Insert into pay_assignment_actions. */
793: hr_nonrun_asact.insact(lockingactid
794: ,ln_primary_assignment_id
795: ,p_pactid
796: ,p_chunk

Line 805: update pay_assignment_actions aa

801: ** Archiver assignment_action and Archiver Payroll_action_id
802: ** so that we need not refer back in the reports.
803: ***********************************************************/
804:
805: update pay_assignment_actions aa
806: set aa.serial_number = to_char(l_person_id)
807: where aa.assignment_action_id = lockingactid;
808:
809: --Added to lock the Amend Archiver

Line 842: update pay_assignment_actions aa

838: ** Archiver assignment_action and Archiver Payroll_action_id
839: ** so that we need not refer back in the reports.
840: ***********************************************************/
841:
842: update pay_assignment_actions aa
843: set aa.serial_number = to_char(l_person_id)
844: where aa.assignment_action_id = lockingactid;
845:
846: --Added to lock previous mag reports

Line 1348: cursor cur_boxo(p_arch_assact_id in pay_assignment_actions.assignment_action_id%TYPE) is

1344: l_further_info_string VARCHAR2(2000);
1345: ln_no_fi_per_slip number;
1346:
1347: /* added these CURSORs for bug 13360884, to get further information*/
1348: cursor cur_boxo(p_arch_assact_id in pay_assignment_actions.assignment_action_id%TYPE) is
1349: SELECT 'RZ-'||substr(fdi.user_name,23,2) code,to_number(fai.value) value
1350: FROM ff_database_items fdi,
1351: ff_archive_items fai
1352: WHERE fai.user_entity_id = fdi.user_entity_id

Line 1357: cursor cur_further_info(p_arch_assact_id in pay_assignment_actions.assignment_action_id%TYPE) is

1353: AND fai.context1 = p_arch_assact_id
1354: AND fdi.user_name like 'CAEOY_RL1_BOXO_AMOUNT____PER_JD_YTD'
1355: ORDER BY substr(fdi.user_name,5,4);
1356:
1357: cursor cur_further_info(p_arch_assact_id in pay_assignment_actions.assignment_action_id%TYPE) is
1358: select substr(ltrim(rtrim(code)),1,60) code, value value
1359: from (
1360: select decode(fdi.user_name,'CAEOY_RL1_FURTHER_INFO_AMOUNT_201_AMT_PER_JD_YTD','201',
1361: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_211_AMT_PER_JD_YTD','211',

Line 1387: pay_assignment_actions paa

1383: to_number(substr(paa.serial_number,3,14)) asgactid , --archiver assignment action id
1384: to_number(substr(paa.serial_number,17,14)) payactid, --archiver payroll action id
1385: paa.assignment_id asgid
1386: FROM
1387: pay_assignment_actions paa
1388: WHERE paa.assignment_action_id = p_assg_actid;
1389:
1390: cursor c_province( p_arch_asact_id number ) is
1391: select fai.value

Line 1422: pay_assignment_actions paa,

1418: ff_database_items fdi,
1419: per_all_people_f ppf,
1420: per_all_assignments_f paf,
1421: pay_action_interlocks pai,
1422: pay_assignment_actions paa,
1423: pay_payroll_actions ppa,
1424: pay_assignment_actions paa_arch
1425: WHERE
1426: paa.assignment_action_id = p_mag_asg_action_id AND

Line 1424: pay_assignment_actions paa_arch

1420: per_all_assignments_f paf,
1421: pay_action_interlocks pai,
1422: pay_assignment_actions paa,
1423: pay_payroll_actions ppa,
1424: pay_assignment_actions paa_arch
1425: WHERE
1426: paa.assignment_action_id = p_mag_asg_action_id AND
1427: ppa.payroll_action_id = paa.payroll_action_id AND
1428: pai.locking_action_id = paa.assignment_action_id AND

Line 1462: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

1458: AND pei.information_type = 'PAY_CA_RL1_FORM_NO'
1459: ORDER BY pei_information7; /*Bug 13564765,15972601*/
1460:
1461: l_original_slpno VARCHAR2(150);
1462: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1463: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1464: l_asg_id per_assignments_f.assignment_id%TYPE;
1465: l_date_earned DATE;
1466: l_province VARCHAR2(30);

Line 1463: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;

1459: ORDER BY pei_information7; /*Bug 13564765,15972601*/
1460:
1461: l_original_slpno VARCHAR2(150);
1462: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1463: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1464: l_asg_id per_assignments_f.assignment_id%TYPE;
1465: l_date_earned DATE;
1466: l_province VARCHAR2(30);
1467: l_O_AutreRevenu VARCHAR2(1000);

Line 3620: FROM pay_assignment_actions paa

3616: ) is
3617:
3618: CURSOR c_get_arch_pay_actid IS
3619: SELECT to_number(substr(paa.serial_number,17,14)) payactid --archiver payroll action id
3620: FROM pay_assignment_actions paa
3621: WHERE paa.assignment_action_id = p_assact_id;
3622: l_final_xml_string VARCHAR2(32000);
3623: l_index NUMBER;
3624: l_address_line hr_locations.address_line_1%TYPE;