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_UIF_ARCHIVE_PKG dependencies on PER_PEOPLE_F

Line 898: l_id_number per_people_f.national_identifier%type;

894: p_effective_date in date
895: ) is
896:
897: -- Employee Data:
898: l_id_number per_people_f.national_identifier%type;
899: l_other_number per_people_f.per_information2%type;
900: l_employee_number per_people_f.employee_number%type;
901: l_last_name per_people_f.last_name%type;
902: l_first_names varchar2(600);

Line 899: l_other_number per_people_f.per_information2%type;

895: ) is
896:
897: -- Employee Data:
898: l_id_number per_people_f.national_identifier%type;
899: l_other_number per_people_f.per_information2%type;
900: l_employee_number per_people_f.employee_number%type;
901: l_last_name per_people_f.last_name%type;
902: l_first_names varchar2(600);
903: l_date_of_birth per_people_f.date_of_birth%type;

Line 900: l_employee_number per_people_f.employee_number%type;

896:
897: -- Employee Data:
898: l_id_number per_people_f.national_identifier%type;
899: l_other_number per_people_f.per_information2%type;
900: l_employee_number per_people_f.employee_number%type;
901: l_last_name per_people_f.last_name%type;
902: l_first_names varchar2(600);
903: l_date_of_birth per_people_f.date_of_birth%type;
904: l_date_employed_from per_periods_of_service.date_start%type;

Line 901: l_last_name per_people_f.last_name%type;

897: -- Employee Data:
898: l_id_number per_people_f.national_identifier%type;
899: l_other_number per_people_f.per_information2%type;
900: l_employee_number per_people_f.employee_number%type;
901: l_last_name per_people_f.last_name%type;
902: l_first_names varchar2(600);
903: l_date_of_birth per_people_f.date_of_birth%type;
904: l_date_employed_from per_periods_of_service.date_start%type;
905: l_date_employed_to per_periods_of_service.actual_termination_date%type;

Line 903: l_date_of_birth per_people_f.date_of_birth%type;

899: l_other_number per_people_f.per_information2%type;
900: l_employee_number per_people_f.employee_number%type;
901: l_last_name per_people_f.last_name%type;
902: l_first_names varchar2(600);
903: l_date_of_birth per_people_f.date_of_birth%type;
904: l_date_employed_from per_periods_of_service.date_start%type;
905: l_date_employed_to per_periods_of_service.actual_termination_date%type;
906: l_leaving_reason per_periods_of_service.leaving_reason%type;
907:

Line 918: from per_people_f per,

914: per.date_of_birth,
915: pos.date_start Date_Employed_From,
916: pos.actual_termination_date Date_Employed_To,
917: pos.leaving_reason
918: from per_people_f per,
919: per_periods_of_service pos
920: where per.person_id = p_person_id
921: -- Bug 4306265: and per.effective_end_date between per.effective_start_date and p_eff_date -- Modified the condition for Bug : 3869426
922: and p_eff_date between per.effective_start_date and per.effective_end_date -- Bug 4306265: re-enabled /* Old Condition Before Bug : 3869426 */