APPS.PAY_IE_P45_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 872: l_first_name per_all_people_f.first_name%TYPE;

868: l_tax_credit NUMBER;
869: l_std_rate_cut_off NUMBER;
870: l_period_type VARCHAR2(20);
871: l_date_of_birth DATE;
872: l_first_name per_all_people_f.first_name%TYPE;
873: l_last_name per_all_people_f.last_name%TYPE;
874: l_bg_id NUMBER;
875: l_commencement_date VARCHAR2(30);
876: -- 13359530

Line 873: l_last_name per_all_people_f.last_name%TYPE;

869: l_std_rate_cut_off NUMBER;
870: l_period_type VARCHAR2(20);
871: l_date_of_birth DATE;
872: l_first_name per_all_people_f.first_name%TYPE;
873: l_last_name per_all_people_f.last_name%TYPE;
874: l_bg_id NUMBER;
875: l_commencement_date VARCHAR2(30);
876: -- 13359530
877: l_usc_yrly_cutoff_1 NUMBER;

Line 917: from per_all_people_f papf,

913: where time_period_id = p_time_period_id;
914:
915: cursor cur_sep_name_dob(p_bg_id NUMBER) is
916: select papf.date_of_birth,papf.first_name, papf.last_name
917: from per_all_people_f papf,
918: per_all_assignments_f pasf
919: where pasf.assignment_id = p_assignment_id
920: and p_date_earned between
921: pasf.effective_start_date and pasf.effective_end_date

Line 2969: PER_ALL_PEOPLE_F paf1,

2965: cursor cur_next_of_kin_details(l_termination_date date) is
2966: SELECT DISTINCT pa.ADDRESS_LINE1 address_line1,pa.ADDRESS_LINE2 address_line2,
2967: pa.ADDRESS_LINE3 address_line3,paf2.LAST_NAME last_name
2968: FROM per_contact_relationships con,
2969: PER_ALL_PEOPLE_F paf1,
2970: PER_ALL_PEOPLE_F paf2,
2971: fnd_lookup_values c ,
2972: per_addresses pa ,
2973: fnd_lookup_values flv

Line 2970: PER_ALL_PEOPLE_F paf2,

2966: SELECT DISTINCT pa.ADDRESS_LINE1 address_line1,pa.ADDRESS_LINE2 address_line2,
2967: pa.ADDRESS_LINE3 address_line3,paf2.LAST_NAME last_name
2968: FROM per_contact_relationships con,
2969: PER_ALL_PEOPLE_F paf1,
2970: PER_ALL_PEOPLE_F paf2,
2971: fnd_lookup_values c ,
2972: per_addresses pa ,
2973: fnd_lookup_values flv
2974: WHERE paf1.PERSON_ID = p_person_id

Line 4783: CURSOR cur_service_leave_year(c_person_id per_all_people_f.person_id%type,c_action_context_id pay_assignment_actions.assignment_action_id%type) IS

4779:
4780:
4781: /* 7291676 */
4782: /* to check whether the termination date of the assignment is after 2009 */
4783: CURSOR cur_service_leave_year(c_person_id per_all_people_f.person_id%type,c_action_context_id pay_assignment_actions.assignment_action_id%type) IS
4784: select 'Y'
4785: from per_periods_of_service ppos
4786: where ppos.person_id = c_person_id
4787: and ppos.period_of_service_id = (select max(paf.period_of_service_id)