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_EOY_RL2_AMEND_ARCH dependencies on PER_ALL_PEOPLE_F

Line 89: lv_sin per_all_people_f.national_identifier%TYPE;

85: ln_business_group_id NUMBER;
86: ln_pre_org_id NUMBER := 0;
87: ln_person_id NUMBER := 0;
88: ln_asg_set NUMBER := 0;
89: lv_sin per_all_people_f.national_identifier%TYPE;
90: lv_year VARCHAR2(4);
91:
92: BEGIN
93: hr_utility.trace('Entered get_payroll_action_info');

Line 171: lv_sin per_all_people_f.national_identifier%TYPE;

167: ln_business_group_id NUMBER;
168: ln_pre_org_id NUMBER := 0;
169: ln_person_id NUMBER := 0;
170: ln_asg_set NUMBER := 0;
171: lv_sin per_all_people_f.national_identifier%TYPE;
172: lv_year VARCHAR2(4);
173: lv_report_type1 pay_payroll_actions.report_type%TYPE;
174: lv_state1 pay_payroll_actions.report_qualifier%type;
175: lv_report_cat1 pay_report_format_mappings_f.report_format%type;

Line 243: lv_sin per_all_people_f.national_identifier%TYPE ;

239: ld_start_date DATE;
240: ln_business_group_id NUMBER;
241: ln_pre_org_id NUMBER;
242: ln_person_id NUMBER := 0;
243: lv_sin per_all_people_f.national_identifier%TYPE ;
244: ln_asg_set NUMBER := 0;
245: lv_year VARCHAR2(4);
246: lv_sql_string VARCHAR2(32000);
247: ln_eoy_pactid number;

Line 350: lv_sin per_all_people_f.national_identifier%TYPE ;

346: ld_start_date DATE;
347: ln_business_group_id NUMBER;
348: ln_person_id NUMBER := 0 ;
349: ln_person_id_sel NUMBER := 0 ;
350: lv_sin per_all_people_f.national_identifier%TYPE ;
351: ln_asg_set NUMBER := 0 ;
352: ln_prev_asg_action_id NUMBER := 0;
353: ln_prev_assignment_id NUMBER := 0;
354: ld_prev_effective_date DATE ;

Line 361: lv_national_identifier per_all_people_f.national_identifier%type;

357:
358:
359: lv_serial_number VARCHAR2(30);
360: ln_eoy_pactid number := 0;
361: lv_national_identifier per_all_people_f.national_identifier%type;
362: lv_message varchar2(100):= null;
363: lv_full_name per_all_people_f.full_name%type;
364: lv_name varchar2(100);
365: lv_record_name varchar2(80);

Line 363: lv_full_name per_all_people_f.full_name%type;

359: lv_serial_number VARCHAR2(30);
360: ln_eoy_pactid number := 0;
361: lv_national_identifier per_all_people_f.national_identifier%type;
362: lv_message varchar2(100):= null;
363: lv_full_name per_all_people_f.full_name%type;
364: lv_name varchar2(100);
365: lv_record_name varchar2(80);
366:
367: -- Variables declared for bug 10399514

Line 464: from per_all_people_f

460: order by paa.assignment_action_id desc;
461:
462: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
463: select substr(full_name,1,31), substr(national_identifier,1,11)
464: from per_all_people_f
465: where person_id = cp_person_id
466: ORDER BY effective_end_date desc;
467:
468: