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

Line 681: l_first_name per_all_people_f.first_name%TYPE;

677: l_tax_credit NUMBER;
678: l_std_rate_cut_off NUMBER;
679: l_period_type VARCHAR2(20);
680: l_date_of_birth DATE;
681: l_first_name per_all_people_f.first_name%TYPE;
682: l_last_name per_all_people_f.last_name%TYPE;
683: l_bg_id NUMBER;
684: l_commencement_date VARCHAR2(30);
685:

Line 682: l_last_name per_all_people_f.last_name%TYPE;

678: l_std_rate_cut_off NUMBER;
679: l_period_type VARCHAR2(20);
680: l_date_of_birth DATE;
681: l_first_name per_all_people_f.first_name%TYPE;
682: l_last_name per_all_people_f.last_name%TYPE;
683: l_bg_id NUMBER;
684: l_commencement_date VARCHAR2(30);
685:
686: -- Commented as PAYE Details are now fetched from Run Results (5128377)

Line 717: from per_all_people_f papf,

713: where time_period_id = p_time_period_id;
714:
715: cursor cur_sep_name_dob(p_bg_id NUMBER) is
716: select papf.date_of_birth,papf.first_name, papf.last_name
717: from per_all_people_f papf,
718: per_all_assignments_f pasf
719: where pasf.assignment_id = p_assignment_id
720: and p_date_earned between
721: pasf.effective_start_date and pasf.effective_end_date