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

Line 299: index(emp.paa_arch,PAY_ASSIGNMENT_ACTIONS_PK)

295:
296: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor', 20);
297:
298: p_sqlstr := 'select /*+ leading(ppa_mag,ppa_arch,paa_arch)
299: index(emp.paa_arch,PAY_ASSIGNMENT_ACTIONS_PK)
300: use_hash(emp.ppa_arch,hoi,tran.ppa_arch)
301: */ distinct to_number(emp.person_id)
302: from pay_ca_eoy_rl2_employee_info_v emp,
303: pay_ca_eoy_rl2_trans_info_v tran,

Line 304: pay_assignment_actions paa_arch,

300: use_hash(emp.ppa_arch,hoi,tran.ppa_arch)
301: */ distinct to_number(emp.person_id)
302: from pay_ca_eoy_rl2_employee_info_v emp,
303: pay_ca_eoy_rl2_trans_info_v tran,
304: pay_assignment_actions paa_arch,
305: pay_payroll_actions ppa_arch,
306: pay_payroll_actions ppa_mag,
307: hr_organization_information hoi
308: where ppa_mag.payroll_action_id = :payroll_action_id

Line 368: pay_assignment_actions paa_arch,

364: paf.effective_end_date,
365: paa_arch.assignment_action_id,
366: ppa_arch.payroll_action_id
367: FROM pay_payroll_actions ppa_arch,
368: pay_assignment_actions paa_arch,
369: per_all_assignments_f paf,
370: hr_organization_information hoi
371: WHERE ppa_arch.report_type = 'RL2'
372: AND ppa_arch.business_group_id+0 = p_business_grpid

Line 504: SELECT pay_assignment_actions_s.nextval

500: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
501:
502: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 40);
503:
504: SELECT pay_assignment_actions_s.nextval
505: INTO lockingactid
506: FROM dual;
507:
508: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 50);

Line 520: update pay_assignment_actions aa

516: */
517:
518: -- hr_utility.trace('updating asg. action');
519:
520: update pay_assignment_actions aa
521: set aa.serial_number = to_char(l_person_id)
522: where aa.assignment_action_id = lockingactid;
523:
524: hr_utility.set_location('pay_ca_rl2_mag.create_assignment_act', 60);

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

1297: /*
1298: This function is used to call from SSHR, to generate
1299: XML for online RL2
1300: */
1301: FUNCTION get_final_xml(p_arch_action_id in pay_assignment_actions.assignment_action_id%TYPE,
1302: p_taxation_year in varchar2,
1303: p_rep_type in varchar2)
1304: RETURN BLOB IS
1305:

Line 1306: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;

1302: p_taxation_year in varchar2,
1303: p_rep_type in varchar2)
1304: RETURN BLOB IS
1305:
1306: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1307: l_asg_id per_assignments_f.assignment_id%TYPE;
1308: lv_negative_bal_flag VARCHAR2(5);
1309: l_is_temp_final_xml VARCHAR2(2);
1310: p_xml_blob BLOB;

Line 1320: from pay_assignment_actions paa

1316: EOL varchar2(10);
1317:
1318: CURSOR c_payroll_asgid(p_arch_asact_id number) is
1319: select paa.payroll_action_id, paa.assignment_id
1320: from pay_assignment_actions paa
1321: where paa.assignment_action_id = p_arch_asact_id;
1322:
1323: /* To get error message */
1324: CURSOR cur_get_meaning(p_lookup_code VARCHAR2) IS

Line 1476: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

1472:
1473:
1474: PROCEDURE xml_employee_record IS
1475:
1476: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1477: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1478: l_asg_id per_assignments_f.assignment_id%TYPE;
1479: l_rep_type pay_report_format_mappings_f.report_type%type;
1480: l_date_earned DATE;

Line 1477: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;

1473:
1474: PROCEDURE xml_employee_record IS
1475:
1476: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1477: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1478: l_asg_id per_assignments_f.assignment_id%TYPE;
1479: l_rep_type pay_report_format_mappings_f.report_type%type;
1480: l_date_earned DATE;
1481: l_taxation_year VARCHAR2(4);

Line 1483: l_rl2pap_asg_actid pay_assignment_actions.assignment_action_id%TYPE;

1479: l_rep_type pay_report_format_mappings_f.report_type%type;
1480: l_date_earned DATE;
1481: l_taxation_year VARCHAR2(4);
1482: l_print_instruction VARCHAR2(1);
1483: l_rl2pap_asg_actid pay_assignment_actions.assignment_action_id%TYPE;
1484: l_rl2pap_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1485: l_transfer_pay_actid NUMBER;
1486: l_business_group_id NUMBER;
1487: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;

Line 1484: l_rl2pap_pay_actid pay_assignment_actions.payroll_action_id%TYPE;

1480: l_date_earned DATE;
1481: l_taxation_year VARCHAR2(4);
1482: l_print_instruction VARCHAR2(1);
1483: l_rl2pap_asg_actid pay_assignment_actions.assignment_action_id%TYPE;
1484: l_rl2pap_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1485: l_transfer_pay_actid NUMBER;
1486: l_business_group_id NUMBER;
1487: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
1488: l_xml_blob BLOB;

Line 1509: pay_assignment_actions paa,

1505: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1506: -- date_earned
1507: FROM
1508: pay_action_interlocks pai,
1509: pay_assignment_actions paa,
1510: pay_payroll_actions ppa,
1511: per_all_people_f ppf,
1512: per_all_assignments_f paf,
1513: pay_action_information pact

Line 1537: pay_assignment_actions paa,

1533: --to_number(substr(paa.serial_number,17,14)) payactid,
1534: paa_arch.payroll_action_id payactid, -- bug 10324391
1535: paa.assignment_id asgid
1536: FROM
1537: pay_assignment_actions paa,
1538: pay_assignment_actions paa_arch -- archiver payroll action_id
1539: WHERE paa.assignment_action_id = p_payactid
1540: AND paa_arch.assignment_action_id = to_number(substr(paa.serial_number,3,14));
1541:

Line 1538: pay_assignment_actions paa_arch -- archiver payroll action_id

1534: paa_arch.payroll_action_id payactid, -- bug 10324391
1535: paa.assignment_id asgid
1536: FROM
1537: pay_assignment_actions paa,
1538: pay_assignment_actions paa_arch -- archiver payroll action_id
1539: WHERE paa.assignment_action_id = p_payactid
1540: AND paa_arch.assignment_action_id = to_number(substr(paa.serial_number,3,14));
1541:
1542: ----------------------------------------------------------------------------------

Line 1608: PROCEDURE fetch_rl2_xml(p_arch_action_id in pay_assignment_actions.assignment_action_id%TYPE,

1604: l_xml_blob);
1605:
1606: END xml_employee_record;
1607:
1608: PROCEDURE fetch_rl2_xml(p_arch_action_id in pay_assignment_actions.assignment_action_id%TYPE,
1609: p_asg_id in per_assignments_f.assignment_id%TYPE,
1610: p_rep_type in varchar2,
1611: p_taxation_year in varchar2,
1612: p_print_instruction in varchar2,

Line 1650: pay_assignment_actions paa

1646: CURSOR c_get_payroll_asg_actid IS
1647: select ppa.payroll_action_id,
1648: ppa.business_group_id
1649: from pay_payroll_actions ppa,
1650: pay_assignment_actions paa
1651: where paa.assignment_action_id = p_arch_action_id
1652: and paa.payroll_action_id = ppa.payroll_action_id;
1653:
1654:

Line 1937: l_rl2pap_pay_actid pay_assignment_actions.payroll_action_id%TYPE;

1933:
1934: l_footnote_code VARCHAR2(100);
1935: l_footnote_amount NUMBER;
1936: l_format_mask VARCHAR2(30);
1937: l_rl2pap_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1938:
1939: /* Added the following new variables for XML Paper report */
1940: tab_employee1 employee_info;
1941: tab_employee2 employee_info;