APPS.PER_NL_DSR_ARCHIVE dependencies on PER_SHARED_TYPES

Line 1677: FROM per_shared_types

1673: CURSOR csr_get_shared_types(c_code IN VARCHAR2
1674: ,c_business_gr_id IN NUMBER
1675: ,c_lookup IN VARCHAR2) IS
1676: SELECT system_type_cd
1677: FROM per_shared_types
1678: WHERE lookup_type = c_lookup
1679: AND information1 = c_code
1680: AND (
1681: business_group_id = c_business_gr_id

Line 1765: l_contract per_shared_types.system_type_cd%TYPE;

1761: l_for_sick_ph_no per_phones.phone_number%TYPE;
1762: l_sick_mobile_no per_phones.phone_number%TYPE;
1763: l_job_name per_jobs.name%TYPE;
1764: l_fz_code per_assignment_extra_info.aei_information3%TYPE;
1765: l_contract per_shared_types.system_type_cd%TYPE;
1766: l_action_info_id NUMBER;
1767: l_ovn NUMBER;
1768: l_exists VARCHAR2(1);
1769: l_chunk_number NUMBER;