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_SS_REP_ARCHIVE_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 800: FROM per_assignment_status_types

796: GROUP BY pee.assignment_id;
797: --
798: CURSOR csr_asg_status_type(c_assignment_status_type_id NUMBER) IS
799: SELECT per_system_status
800: FROM per_assignment_status_types
801: WHERE assignment_status_type_id = c_assignment_status_type_id;
802: --
803: l_effective_report_date effective_report_date_list;
804: l_event event_list;

Line 832: l_system_status per_assignment_status_types.per_system_status%TYPE;

828: l_collective_agreement NUMBER;
829: l_disability_degree NUMBER;
830: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
831: l_sex per_all_people_f.sex%TYPE;
832: l_system_status per_assignment_status_types.per_system_status%TYPE;
833: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
834: l_contract_key pay_element_entry_values_f.screen_entry_value%TYPE;
835: --
836: BEGIN

Line 981: ,per_assignment_status_types pas

977: ,pap.date_of_birth date_of_birth
978: ,pap.sex sex
979: from per_all_assignments_f paa
980: ,per_all_people_f pap
981: ,per_assignment_status_types pas
982: where paa.assignment_id = '||p_assignment_id||'
983: and paa.person_id = pap.person_id
984: and paa.assignment_status_type_id = pas.assignment_status_type_id
985: and pas.per_system_status = ''ACTIVE_ASSIGN''