DBA Data[Home] [Help]

APPS.PQP_EXCP_RPT dependencies on HR_LOOKUPS

Line 136: FROM hr_lookups

132: p_legislation_code pqp_exception_reports.legislation_code%TYPE
133: )
134: IS
135: SELECT meaning
136: FROM hr_lookups
137: WHERE lookup_type='PQP_COMPARISON_TYPE'
138: AND lookup_code=(
139: SELECT comparison_type
140: FROM pqp_exception_reports

Line 159: hr_lookups hrl

155: )
156: IS
157: SELECT distinct hrl.meaning
158: FROM pqp_exception_reports per,
159: hr_lookups hrl
160: WHERE per.exception_report_id=p_report_id
161: AND (per.business_group_id IS NULL
162: OR per.business_group_id=p_business_group_id)
163: AND (per.legislation_code IS NULL

Line 179: FROM HR_LOOKUPS HRL

175: p_legislation_code pqp_exception_reports.legislation_code%TYPE
176: )
177: IS
178: SELECT meaning
179: FROM HR_LOOKUPS HRL
180: WHERE HRL.LOOKUP_TYPE = 'PQP_OPERATOR_TYPES'
181: AND HRL.ENABLED_FLAG = 'Y'
182: AND LOOKUP_CODE =(
183: SELECT distinct variance_operator