APPS.PAY_CA_RL2_AMEND_MAG dependencies on PER_PEOPLE_F

Line 492: from per_people_f

488: legislative_parameters) = to_char(cp_pre);
489:
490: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
491: select substr(full_name,1,48), employee_number
492: from per_people_f
493: where person_id = cp_person_id
494: order by effective_end_date desc;
495:
496: CURSOR c_get_prov_amend_flag(cp_asg_act_id number) IS

Line 545: lv_employee_number per_people_f.employee_number%type;

541: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
542: ln_pre_id_null number;
543: ln_iteration number := 0;
544: lv_flag_count number := 0;
545: lv_employee_number per_people_f.employee_number%type;
546: lv_message varchar2(100):= null;
547: lv_full_name per_people_f.full_name%type;
548: lv_record_name varchar2(100);
549: lv_prov_of_emp varchar2(10);

Line 547: lv_full_name per_people_f.full_name%type;

543: ln_iteration number := 0;
544: lv_flag_count number := 0;
545: lv_employee_number per_people_f.employee_number%type;
546: lv_message varchar2(100):= null;
547: lv_full_name per_people_f.full_name%type;
548: lv_record_name varchar2(100);
549: lv_prov_of_emp varchar2(10);
550: lv_prov_amend_flag varchar2(5);
551: ln_serial_number pay_assignment_actions.serial_number%TYPE;

Line 1449: /* Bug 15972601 - Removed join with per_people_f table due

1445: and trim(hl.lookup_code) = trim(p_rl2_source_of_income)
1446: and to_date('31/12/'||p_taxation_year,'dd/mm/yyyy')<= nvl(hl.end_date_active,to_date('31/12/4712','dd/mm/yyyy'))
1447: and hl.enabled_flag='Y';
1448:
1449: /* Bug 15972601 - Removed join with per_people_f table due
1450: to which duplicate records are fetched. */
1451: CURSOR c_original_slipno (p_person IN VARCHAR,p_tax_year IN VARCHAR,p_trans_id IN NUMBER) IS
1452: SELECT pei_information7
1453: FROM per_people_extra_info pei

Line 1549: l_person_id per_people_f.person_id%TYPE;

1545: lBoxC_SinglePayAccUnreg NUMBER;
1546: lBoxC_ExcessAmtSinPayTrans NUMBER;
1547: lCode_dereleve NUMBER;
1548:
1549: l_person_id per_people_f.person_id%TYPE;
1550: l_address_line1 per_addresses.address_line1%TYPE;
1551: l_address_line2 per_addresses.address_line2%TYPE;
1552: l_address_line3 per_addresses.address_line3%TYPE;
1553: l_city per_addresses.town_or_city%TYPE;