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_US_W2C_RPT dependencies on PAY_PAYROLL_ACTIONS

Line 147: from pay_payroll_actions ppa

143: pay_us_payroll_utils.get_parameter('S3',ppa.legislative_parameters),
144: to_date(pay_us_payroll_utils.get_parameter('EFFECTIVE_DATE',
145: ppa.legislative_parameters)
146: ,'dd-mon-yyyy')
147: from pay_payroll_actions ppa
148: where ppa.payroll_action_id = cp_payroll_action_id;
149:
150: ld_end_date DATE;
151: ld_start_date DATE;

Line 330: pay_payroll_actions ppa

326: ELSE
327: lv_sql_string :=
328: 'select distinct paa.serial_number
329: from pay_assignment_actions paa,
330: pay_payroll_actions ppa
331: where ppa.report_type = ''W2C_PRE_PROCESS''
332: and ppa.effective_date = add_months(''' || ld_start_date || ''',12) -1
333: and ppa.business_group_id+0 = ' || ln_business_group_id ||'
334: and ltrim(rtrim(

Line 393: lv_report_type pay_payroll_actions.report_type%TYPE ;

389: lv_sort2 VARCHAR2(60);
390: lv_sort3 VARCHAR2(60);
391: ld_session_date DATE;
392:
393: lv_report_type pay_payroll_actions.report_type%TYPE ;
394: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
395: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;
396: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
397:

Line 404: lv_prev_report_type pay_payroll_actions.report_type%TYPE;

400: lv_employee_number per_all_people_f.employee_number%type;
401: lv_message varchar2(50);
402: lv_full_name per_all_people_f.full_name%type;
403: lv_record_name varchar2(50);
404: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
405: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
406: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
407: ln_serial_number pay_assignment_actions.serial_number%TYPE;
408:

Line 431: pay_payroll_actions ppa,

427: cp_business_group_id in number,
428: cp_tax_unit_id in number) IS
429: select distinct paf.person_id
430: from pay_assignment_actions paa,
431: pay_payroll_actions ppa,
432: per_all_assignments_f paf
433: where ppa.report_type = 'W-2C PAPER'
434: and ppa.report_category = 'REPORT'
435: and ppa.report_qualifier = 'DEFAULT'

Line 460: from pay_payroll_actions ppa,

456: ,cp_effective_date in date
457: ,cp_start_date in date) is
458: select ppa.report_type, paa.assignment_id,
459: paa.assignment_action_id
460: from pay_payroll_actions ppa,
461: pay_assignment_actions paa,
462: per_all_assignments_f paf
463: where paa.assignment_id = paf.assignment_id
464: and paf.person_id = cp_person_id

Line 486: from pay_payroll_actions ppa,

482: ,cp_start_date in date
483: ,cp_business_group_id in number) is
484: select ppa.report_type, paa.assignment_id,
485: paa.assignment_action_id
486: from pay_payroll_actions ppa,
487: pay_assignment_actions paa,
488: per_all_assignments_f paf
489: where paa.assignment_id = paf.assignment_id
490: and paf.person_id = cp_person_id

Line 509: pay_payroll_Actions ppa_paper

505: AND paf1.effective_start_date <= ppa.effective_date)
506: and exists (select 1
507: from pay_action_interlocks pai,
508: pay_assignment_actions paa_paper,
509: pay_payroll_Actions ppa_paper
510: where pai.locked_action_id = paa.assignment_action_id
511: and paa_paper.assignment_Action_id = pai.locking_action_id
512: and ppa_paper.payroll_Action_id = paa_paper.payroll_Action_id
513: and ppa_paper.report_type in ('W-2C PAPER','W2C_XML')

Line 524: from pay_payroll_actions ppa,

520: CURSOR get_interlocked_action(cp_w2cpp_action in number)is
521: select ppa.report_type,
522: paa.assignment_action_id,
523: substr(paa.serial_number, 1,15) prev_action_id
524: from pay_payroll_actions ppa,
525: pay_assignment_actions paa,
526: pay_action_interlocks pai
527: where pai.locking_action_id = cp_w2cpp_action
528: and paa.assignment_action_id = pai.locked_action_id

Line 1558: FROM pay_payroll_actions ppa

1554:
1555: CURSOR c_get_session_date IS
1556: SELECT NVL(TO_DATE(TO_CHAR(TO_DATE(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',
1557: ppa.legislative_parameters),'DD-MON-YYYY'),'YYYY/MM/DD'),'YYYY/MM/DD'),SYSDATE) session_date
1558: FROM pay_payroll_actions ppa
1559: WHERE payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1560:
1561: c_get_session_date_rec c_get_session_date%ROWTYPE;
1562:

Line 1571: from pay_payroll_actions ppa

1567: --
1568: CURSOR csr_get_eoy_info(cp_w2c_eff_date in date
1569: ,cp_w2c_tax_unit_id in number) is
1570: select ppa.payroll_action_id
1571: from pay_payroll_actions ppa
1572: where ppa.report_type = 'YREND'
1573: and ppa.effective_date = cp_w2c_eff_date
1574: and pay_us_w2c_arch.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
1575: = cp_w2c_tax_unit_id;

Line 2853: lv_report_type pay_payroll_actions.report_type%TYPE ;

2849: l_state_local_count_completed number;
2850: l_w2c_set_cnt number;
2851: l_is_temp_xml_string VARCHAR2(2);
2852: lv_full_name per_all_people_f.full_name%type;
2853: lv_report_type pay_payroll_actions.report_type%TYPE ;
2854: lv_message varchar2(350);
2855: lv_record_name varchar2(50);
2856:
2857: procedure compare_data(l_w2c_fields_o l_w2c_fields_rec,

Line 3628: pay_payroll_actions ppa

3624: hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),
3625: hr_us_w2_mt.get_parameter('p_instr_template',ppa.legislative_parameters),
3626: hr_us_w2_mt.get_parameter('print_instrunction',ppa.legislative_parameters)
3627: FROM pay_assignment_actions paa,
3628: pay_payroll_actions ppa
3629: where ppa.payroll_action_id = paa.payroll_action_id
3630: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
3631:
3632: BEGIN