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_ASSIGNMENTS_F

Line 880: l_assgno per_all_assignments_f.assignment_number%type;

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 ;
884: l_msgtext varchar2(2000);

Line 899: per_all_assignments_f asgn2,

895: CURSOR emp_number_cur ( asgn_ac_id pay_assignment_actions.assignment_action_id%TYPE) IS
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

Line 3140: asg_no per_all_assignments_f.assignment_number%type

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;
3143: l_miss_LE_tab missing_LE_table;
3144: l_ee_msg_tab msgtext_tab;

Line 3158: l_assignment_id per_all_assignments_f.assignment_id%type;

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;
3162: l_fname per_all_people_f.first_name%type;

Line 3160: l_asg_no per_all_assignments_f.assignment_number%type;

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;
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;

Line 3165: l_location_id per_all_assignments_f.location_id%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;
3169: l_org_location_id hr_all_organization_units.location_id%type;

Line 3166: l_position_id per_all_assignments_f.position_id%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;
3169: l_org_location_id hr_all_organization_units.location_id%type;
3170: l_passport_no varchar2(150);

Line 3167: l_organization_id per_all_assignments_f.organization_id%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;
3169: l_org_location_id hr_all_organization_units.location_id%type;
3170: l_passport_no varchar2(150);
3171: l_country_passport varchar2(150);

Line 3308: from per_all_assignments_f paaf

3304:
3305: --Fetch the least of assignment's max effective end date and tax year end date
3306: select least(max(paaf.effective_end_date),p_tax_year_end)
3307: into l_effective_date
3308: from per_all_assignments_f paaf
3309: where paaf.effective_start_date <= p_tax_year_end
3310: and paaf.assignment_id = l_assignment_id;
3311:
3312: hr_utility.set_location('l_effective_date:'||to_char(l_effective_date,'dd-mon-yyyy'),10);

Line 3940: per_all_assignments_f asgn2,

3936: --Fetch the assignment details
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

Line 4316: l_assgno per_all_assignments_f.assignment_number%type;

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);
4320: l_code number(4);