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

Line 879: l_empno per_all_people_f.employee_number%type;

875: TYPE lmpsm_code_tab IS TABLE OF number Index BY VARCHAR2(50); --Index by Code||Tax Directive Number
876: retiremnt_fund_lmpsum lmpsm_code_tab;
877:
878:
879: l_empno per_all_people_f.employee_number%type;
880: l_assgno per_all_assignments_f.assignment_number%type;
881: l_tax_ytd ff_archive_items.value%TYPE ; -- to save Tax paid by employee during tax year
882: l_site ff_archive_items.value%TYPE ;
883: l_paye ff_archive_items.value%TYPE ;

Line 900: per_all_people_f per,

896: SELECT per.employee_number empno, asgn2.assignment_number assgno,
897: add_months(per.date_of_birth,780) dateb--Added for TYE09
898: FROM pay_assignment_actions paa,
899: per_all_assignments_f asgn2,
900: per_all_people_f per,
901: pay_payroll_actions ppa
902: WHERE paa.assignment_action_id = asgn_ac_id
903: AND ppa.payroll_action_id = paa.payroll_action_id
904: AND asgn2.assignment_id = paa.assignment_id

Line 914: from per_all_people_f per2

910: and paf2.assignment_id = asgn2.assignment_id
911: )
912: AND per.effective_start_date =
913: ( select max(per2.effective_start_date)
914: from per_all_people_f per2
915: where per2.effective_start_date <= ppa.effective_date
916: and per2.person_id = per.person_id
917: );
918: --End changes for Bug No 6749775

Line 1875: from per_all_people_f per

1871: --Employee Name Info
1872: if P_PERSON_ID is not null then
1873: select substr(per.full_name,1,40)
1874: into l_person_name
1875: from per_all_people_f per
1876: where person_id=P_PERSON_ID
1877: and per.effective_start_date = ( select max(effective_start_date) from per_all_people_f per1
1878: where per.person_id=per1.person_id
1879: and P_TAX_YEAR_END between per1.effective_start_date and per1.effective_end_date);

Line 1877: and per.effective_start_date = ( select max(effective_start_date) from per_all_people_f per1

1873: select substr(per.full_name,1,40)
1874: into l_person_name
1875: from per_all_people_f per
1876: where person_id=P_PERSON_ID
1877: and per.effective_start_date = ( select max(effective_start_date) from per_all_people_f per1
1878: where per.person_id=per1.person_id
1879: and P_TAX_YEAR_END between per1.effective_start_date and per1.effective_end_date);
1880: end if;
1881:

Line 2375: where parent_table = 'PER_ALL_PEOPLE_F'

2371: select translate(upper(phone_number),
2372: '0123456789+-. ',
2373: '0123456789') -- remove any character other than digits
2374: from per_phones
2375: where parent_table = 'PER_ALL_PEOPLE_F'
2376: and parent_id = p_person_id
2377: and phone_type = p_phone_type
2378: and p_effective_date between date_from and nvl(date_to,to_date('31-12-4712','DD-MM-YYYY')) ;
2379:

Line 3138: ( emp_no per_all_people_f.employee_number%type,

3134:
3135: l_proc varchar2(250) :='PAY_ZA_EOY_VAL.get_employee_info';
3136: rec_employee csr_employee%type;
3137: type missing_LE_rec is record
3138: ( emp_no per_all_people_f.employee_number%type,
3139: emp_name varchar2(600),
3140: asg_no per_all_assignments_f.assignment_number%type
3141: );
3142: type missing_LE_table is table of missing_LE_rec index by binary_integer;

Line 3156: l_emp_no per_all_people_f.employee_number%type;

3152: l_miss_LE_warn_info varchar2(1):='N';
3153: rec_sars_bus_address csr_sars_address%rowtype;
3154: rec_sars_res_address csr_sars_address%rowtype;
3155: rec_postal_address csr_postal_address%rowtype;
3156: l_emp_no per_all_people_f.employee_number%type;
3157: l_person_id per_all_people_f.person_id%type;
3158: l_assignment_id per_all_assignments_f.assignment_id%type;
3159: l_emp_name varchar2(600);
3160: l_asg_no per_all_assignments_f.assignment_number%type;

Line 3157: l_person_id per_all_people_f.person_id%type;

3153: rec_sars_bus_address csr_sars_address%rowtype;
3154: rec_sars_res_address csr_sars_address%rowtype;
3155: rec_postal_address csr_postal_address%rowtype;
3156: l_emp_no per_all_people_f.employee_number%type;
3157: l_person_id per_all_people_f.person_id%type;
3158: l_assignment_id per_all_assignments_f.assignment_id%type;
3159: l_emp_name varchar2(600);
3160: l_asg_no per_all_assignments_f.assignment_number%type;
3161: l_lname per_all_people_f.last_name%type;

Line 3161: l_lname per_all_people_f.last_name%type;

3157: l_person_id per_all_people_f.person_id%type;
3158: l_assignment_id per_all_assignments_f.assignment_id%type;
3159: l_emp_name varchar2(600);
3160: l_asg_no per_all_assignments_f.assignment_number%type;
3161: l_lname per_all_people_f.last_name%type;
3162: l_fname per_all_people_f.first_name%type;
3163: l_mname per_all_people_f.middle_names%type;
3164: l_ni per_all_people_f.national_identifier%type;
3165: l_location_id per_all_assignments_f.location_id%type;

Line 3162: l_fname per_all_people_f.first_name%type;

3158: l_assignment_id per_all_assignments_f.assignment_id%type;
3159: l_emp_name varchar2(600);
3160: l_asg_no per_all_assignments_f.assignment_number%type;
3161: l_lname per_all_people_f.last_name%type;
3162: l_fname per_all_people_f.first_name%type;
3163: l_mname per_all_people_f.middle_names%type;
3164: l_ni per_all_people_f.national_identifier%type;
3165: l_location_id per_all_assignments_f.location_id%type;
3166: l_position_id per_all_assignments_f.position_id%type;

Line 3163: l_mname per_all_people_f.middle_names%type;

3159: l_emp_name varchar2(600);
3160: l_asg_no per_all_assignments_f.assignment_number%type;
3161: l_lname per_all_people_f.last_name%type;
3162: l_fname per_all_people_f.first_name%type;
3163: l_mname per_all_people_f.middle_names%type;
3164: l_ni per_all_people_f.national_identifier%type;
3165: l_location_id per_all_assignments_f.location_id%type;
3166: l_position_id per_all_assignments_f.position_id%type;
3167: l_organization_id per_all_assignments_f.organization_id%type;

Line 3164: l_ni per_all_people_f.national_identifier%type;

3160: l_asg_no per_all_assignments_f.assignment_number%type;
3161: l_lname per_all_people_f.last_name%type;
3162: l_fname per_all_people_f.first_name%type;
3163: l_mname per_all_people_f.middle_names%type;
3164: l_ni per_all_people_f.national_identifier%type;
3165: l_location_id per_all_assignments_f.location_id%type;
3166: l_position_id per_all_assignments_f.position_id%type;
3167: l_organization_id per_all_assignments_f.organization_id%type;
3168: l_pos_location_id per_all_positions.location_id%type;

Line 3175: l_email per_all_people_f.email_address%type;

3171: l_country_passport varchar2(150);
3172: l_id_dob number(1);
3173: l_it_no_val number(1);
3174: l_it_no_value varchar2(150);
3175: l_email per_all_people_f.email_address%type;
3176: l_emp_trading_name varchar2(150);
3177: l_emp_cc_no varchar2(150);
3178: l_nature varchar2(3);
3179: l_legal_entity varchar2(150);

Line 3243: per_all_people_f per,

3239: from hr_all_organization_units haou
3240: where haou.organization_id=ass.organization_id) org_location_id
3241: from
3242: per_assignments_f ass,
3243: per_all_people_f per,
3244: per_assignment_extra_info aei
3245: where
3246: ass.payroll_id = nvl(:1,ass.payroll_id)
3247: and ass.business_group_id=:2

Line 3941: per_all_people_f per

3937: CURSOR emp_number_cur ( asgn_ac_id pay_assignment_actions.assignment_action_id%TYPE) IS
3938: SELECT per.employee_number empno, asgn2.assignment_number assgno
3939: FROM pay_assignment_actions paa,
3940: per_all_assignments_f asgn2,
3941: per_all_people_f per
3942: WHERE paa.assignment_action_id = asgn_ac_id
3943: AND asgn2.assignment_id = paa.assignment_id
3944: AND per.person_id = asgn2.person_id
3945: AND asgn2.effective_start_date =

Line 4315: l_empno per_all_people_f.employee_number%type;

4311:
4312: rec_info tax_info%rowtype;
4313: --rec_ret_fund_ls chk_ret_fund_ls%rowtype;
4314: l_msgtext varchar2(2000);
4315: l_empno per_all_people_f.employee_number%type;
4316: l_assgno per_all_assignments_f.assignment_number%type;
4317: l_count number(1):=0;
4318: l_main_cert_num varchar2(30);
4319: l_cert_type varchar2(10);