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 PER_ALL_PEOPLE_F

Line 400: lv_employee_number per_all_people_f.employee_number%type;

396: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
397:
398:
399: lv_serial_number VARCHAR2(30);
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;

Line 402: lv_full_name per_all_people_f.full_name%type;

398:
399: lv_serial_number VARCHAR2(30);
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;

Line 534: from per_all_people_f

530:
531:
532: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
533: select substr(full_name,1,48), employee_number
534: from per_all_people_f
535: where person_id = cp_person_id
536: order by effective_end_date desc;
537:
538: BEGIN

Line 1370: l_first_name per_all_people_f.first_name%type;

1366: p_assignment_id NUMBER;
1367: l_person_id NUMBER;
1368: l_profile_date_string VARCHAR2(40);
1369: /* 6500188 */
1370: l_first_name per_all_people_f.first_name%type;
1371: l_middle_name per_all_people_f.middle_names%type;
1372: l_dummy varchar2(100);
1373: l_dummy_2 varchar2(100);
1374: l_full_name per_all_people_f.full_name%type;

Line 1371: l_middle_name per_all_people_f.middle_names%type;

1367: l_person_id NUMBER;
1368: l_profile_date_string VARCHAR2(40);
1369: /* 6500188 */
1370: l_first_name per_all_people_f.first_name%type;
1371: l_middle_name per_all_people_f.middle_names%type;
1372: l_dummy varchar2(100);
1373: l_dummy_2 varchar2(100);
1374: l_full_name per_all_people_f.full_name%type;
1375: l_nj_sdi1_value varchar2(20) ;

Line 1374: l_full_name per_all_people_f.full_name%type;

1370: l_first_name per_all_people_f.first_name%type;
1371: l_middle_name per_all_people_f.middle_names%type;
1372: l_dummy varchar2(100);
1373: l_dummy_2 varchar2(100);
1374: l_full_name per_all_people_f.full_name%type;
1375: l_nj_sdi1_value varchar2(20) ;
1376: l_flipp_id varchar2(20) ;
1377: l_state_zero_flag varchar2(10) ;
1378: get_old_state_not_f boolean;

Line 2852: lv_full_name per_all_people_f.full_name%type;

2848: l_state_local_total_count number;
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: