DBA Data[Home] [Help]

APPS.PQH_EMPLOYMENT_CATEGORY dependencies on PER_SHARED_TYPES

Line 155: FROM per_shared_types

151: l_ret_months NUMBER;
152: l_conv_factor NUMBER;
153: CURSOR csr_conv_factor IS
154: SELECT information1
155: FROM per_shared_types
156: WHERE lookup_type = 'QUALIFYING_UNITS'
157: AND business_group_id = p_business_group_id
158: AND system_type_cd = p_duration_units
159: UNION ALL

Line 161: FROM per_shared_types

157: AND business_group_id = p_business_group_id
158: AND system_type_cd = p_duration_units
159: UNION ALL
160: SELECT information1
161: FROM per_shared_types
162: WHERE lookup_type = 'QUALIFYING_UNITS'
163: AND business_group_id IS NULL
164: AND system_type_cd = p_duration_units;
165: BEGIN