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.PER_ES_COMP_CERT_ARCHIVE_PKG dependencies on PER_SHARED_TYPES

Line 592: l_leaving_reason per_shared_types.information1%type;

588: l_found BOOLEAN;
589: l_employee_data csr_employee_data%rowtype;
590: l_contract_data csr_contract_data%rowtype;
591: l_emp_ss_id csr_get_ss_id%rowtype;
592: l_leaving_reason per_shared_types.information1%type;
593: l_action_info_id number;
594: l_emp_occupation per_jobs_tl.name%type;
595: l_ovn number;
596: l_vac_days number;

Line 602: FROM per_shared_types

598:
599:
600: CURSOR csr_stat_leav_reas_bgspec(c_business_group_id NUMBER) IS
601: SELECT hr_general.decode_lookup('STAT_TERM_REASONS',information1) prov
602: FROM per_shared_types
603: WHERE lookup_type ='LEAV_REAS'
604: AND system_type_cd = l_employee_data.leaving_reason
605: AND business_group_id = c_business_group_id;
606:

Line 609: FROM per_shared_types

605: AND business_group_id = c_business_group_id;
606:
607: CURSOR csr_stat_leav_reas IS
608: SELECT hr_general.decode_lookup('STAT_TERM_REASONS',information1) prov
609: FROM per_shared_types
610: WHERE lookup_type ='LEAV_REAS'
611: AND system_type_cd = l_employee_data.leaving_reason
612: AND business_group_id IS NULL;
613: