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_ASSIGNMENT_ACTIONS

Line 431: pay_assignment_actions paa,

427: from ff_archive_items fai1,
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

Line 493: pay_assignment_actions paa,

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
497: WHERE ppa1.payroll_action_id = p_pactid

Line 607: SELECT pay_assignment_actions_s.nextval

603: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
604: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
605: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 40);
606:
607: SELECT pay_assignment_actions_s.nextval
608: INTO lockingactid
609: FROM dual;
610:
611: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 50);

Line 624: update pay_assignment_actions aa

620: */
621:
622: -- hr_utility.trace('updating asg. action');
623:
624: update pay_assignment_actions aa
625: set aa.serial_number = to_char(l_person_id)
626: where aa.assignment_action_id = lockingactid;
627:
628: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 60);

Line 1232: FUNCTION get_final_xml(p_arch_action_id in pay_assignment_actions.assignment_action_id%TYPE,

1228: /*
1229: This function is used to call from SSHR, to generate
1230: XML for online RL1
1231: */
1232: FUNCTION get_final_xml(p_arch_action_id in pay_assignment_actions.assignment_action_id%TYPE,
1233: p_taxation_year in varchar2,
1234: p_rep_type in varchar2)
1235: RETURN BLOB IS
1236:

Line 1237: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;

1233: p_taxation_year in varchar2,
1234: p_rep_type in varchar2)
1235: RETURN BLOB IS
1236:
1237: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1238: l_asg_id per_assignments_f.assignment_id%TYPE;
1239: l_province varchar2(30);
1240: lv_negative_bal_flag VARCHAR2(5);
1241: l_is_temp_final_xml VARCHAR2(2);

Line 1260: from pay_assignment_actions paa

1256: and fai.context1 =p_arch_asact_id;
1257:
1258: CURSOR c_payroll_asgid(p_arch_asact_id number) is
1259: select paa.payroll_action_id, paa.assignment_id
1260: from pay_assignment_actions paa
1261: where paa.assignment_action_id = p_arch_asact_id;
1262:
1263: /* To get error message */
1264: CURSOR cur_get_meaning(p_lookup_code VARCHAR2) IS

Line 1398: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

1394: /*************************** *******************************/
1395:
1396: PROCEDURE xml_employee_record IS
1397:
1398: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1399: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1400: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1401: l_asg_id per_assignments_f.assignment_id%TYPE;
1402: l_date_earned DATE;

Line 1399: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;

1395:
1396: PROCEDURE xml_employee_record IS
1397:
1398: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1399: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1400: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1401: l_asg_id per_assignments_f.assignment_id%TYPE;
1402: l_date_earned DATE;
1403: l_province VARCHAR2(30);

Line 1400: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;

1396: PROCEDURE xml_employee_record IS
1397:
1398: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1399: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1400: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1401: l_asg_id per_assignments_f.assignment_id%TYPE;
1402: l_date_earned DATE;
1403: l_province VARCHAR2(30);
1404: l_payroll_actid NUMBER;

Line 1416: FROM pay_assignment_actions paa,

1412: to_number(substr(paa.serial_number,3,14)) asgactid , --archiver assignment action id
1413: --to_number(substr(paa.serial_number,17,14)) payactid, --archiver payroll action id
1414: paa_arch.payroll_action_id payactid,
1415: paa.assignment_id asgid
1416: FROM pay_assignment_actions paa,
1417: pay_assignment_actions paa_arch -- archiver payroll action_id niranjan
1418:
1419: WHERE paa.assignment_action_id = p_assg_actid
1420: AND paa_arch.assignment_action_id = to_number(substr(paa.serial_number,3,14));

Line 1417: pay_assignment_actions paa_arch -- archiver payroll action_id niranjan

1413: --to_number(substr(paa.serial_number,17,14)) payactid, --archiver payroll action id
1414: paa_arch.payroll_action_id payactid,
1415: paa.assignment_id asgid
1416: FROM pay_assignment_actions paa,
1417: pay_assignment_actions paa_arch -- archiver payroll action_id niranjan
1418:
1419: WHERE paa.assignment_action_id = p_assg_actid
1420: AND paa_arch.assignment_action_id = to_number(substr(paa.serial_number,3,14));
1421:

Line 1443: pay_assignment_actions paa,

1439: ff_database_items fdi,
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

Line 1445: pay_assignment_actions paa_arch

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
1449: pai.locking_action_id = paa.assignment_action_id AND

Line 1545: PROCEDURE fetch_rl1_xml(p_arch_action_id in pay_assignment_actions.assignment_action_id%TYPE,

1541: /*===========================================================
1542: This procedure is used to generate XML data. That XML data is used
1543: in RL1 CP and in online RL1
1544: =============================================================*/
1545: PROCEDURE fetch_rl1_xml(p_arch_action_id in pay_assignment_actions.assignment_action_id%TYPE,
1546: p_arch_pay_actid in pay_assignment_actions.payroll_action_id%TYPE,
1547: p_asg_id in per_assignments_f.assignment_id%TYPE,
1548: p_rep_type in varchar2,
1549: p_province in varchar2,

Line 1546: p_arch_pay_actid in pay_assignment_actions.payroll_action_id%TYPE,

1542: This procedure is used to generate XML data. That XML data is used
1543: in RL1 CP and in online RL1
1544: =============================================================*/
1545: PROCEDURE fetch_rl1_xml(p_arch_action_id in pay_assignment_actions.assignment_action_id%TYPE,
1546: p_arch_pay_actid in pay_assignment_actions.payroll_action_id%TYPE,
1547: p_asg_id in per_assignments_f.assignment_id%TYPE,
1548: p_rep_type in varchar2,
1549: p_province in varchar2,
1550: p_taxation_year in varchar2,

Line 4609: FROM pay_assignment_actions paa

4605: ) is
4606:
4607: CURSOR c_get_arch_pay_actid IS
4608: /* SELECT to_number(substr(paa.serial_number,17,14)) payactid --archiver payroll action id
4609: FROM pay_assignment_actions paa
4610: WHERE paa.assignment_action_id = p_assact_id;*/--niranjan
4611: SELECT payroll_action_id
4612: FROM pay_assignment_actions paa
4613: WHERE paa.assignment_action_id = p_assact_id;

Line 4612: FROM pay_assignment_actions paa

4608: /* SELECT to_number(substr(paa.serial_number,17,14)) payactid --archiver payroll action id
4609: FROM pay_assignment_actions paa
4610: WHERE paa.assignment_action_id = p_assact_id;*/--niranjan
4611: SELECT payroll_action_id
4612: FROM pay_assignment_actions paa
4613: WHERE paa.assignment_action_id = p_assact_id;
4614:
4615: l_final_xml_string VARCHAR2(32000);
4616: l_index NUMBER;