APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on PER_SHARED_TYPES

Line 108: FROM per_shared_types

104: ,p_business_group_id NUMBER) RETURN VARCHAR2 IS
105: --
106: CURSOR csr_system_type_cd IS
107: SELECT system_type_cd
108: FROM per_shared_types
109: WHERE lookup_type = 'ES_NATIONALITY'
110: AND NVL(business_group_id,p_business_group_id)
111: = p_business_group_id
112: AND information1 = p_lookup_code;

Line 119: l_iso_code per_shared_types.system_type_cd%TYPE;

115: SELECT iso_numeric_code
116: FROM fnd_territories
117: WHERE territory_code = p_lookup_code;
118: --
119: l_iso_code per_shared_types.system_type_cd%TYPE;
120: --
121: BEGIN
122: --
123: IF p_employer_employee = 'EMPLOYEE' THEN

Line 1185: FROM per_shared_types

1181: --
1182: CURSOR csr_stat_leav_reas_bgspec(c_leaving_reason VARCHAR2
1183: ,c_business_group_id NUMBER ) IS
1184: SELECT information1
1185: FROM per_shared_types
1186: WHERE lookup_type ='LEAV_REAS'
1187: AND system_type_cd = c_leaving_reason
1188: AND business_group_id = c_business_group_id;
1189: --

Line 1192: FROM per_shared_types

1188: AND business_group_id = c_business_group_id;
1189: --
1190: CURSOR csr_stat_leav_reas(c_leaving_reason VARCHAR2)IS
1191: SELECT information1
1192: FROM per_shared_types
1193: WHERE lookup_type ='LEAV_REAS'
1194: AND system_type_cd = c_leaving_reason
1195: AND business_group_id IS NULL;
1196: --

Line 1230: l_leave_reason_code per_shared_types.information1%TYPE;

1226: l_employee_category_ter VARCHAR2(30);
1227: l_collective_agreement_ter NUMBER;
1228: l_disability_degree_ter NUMBER;
1229: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;
1230: l_leave_reason_code per_shared_types.information1%TYPE;
1231: --
1232: BEGIN
1233: OPEN csr_get_asg_values(p_assignment_id, p_effective_end_date);
1234: FETCH csr_get_asg_values INTO l_employee_category, l_collective_agreement;