DBA Data[Home] [Help]

APPS.PQH_DE_CHILD_SEQ_PKG dependencies on PER_DISABILITIES_V

Line 183: from PER_DISABILITIES_V pdf

179: select pdf.DISABILITY_ID,
180: pdf.CATEGORY,
181: pdf.STATUS
182:
183: from PER_DISABILITIES_V pdf
184: where pdf.PERSON_ID=lPERSON_ID
185: and pdf.BUSINESS_GROUP_ID=lBusiness_group_id
186: and pdf.EFFECTIVE_START_DATE <= l_session_date
187: and pdf.EFFECTIVE_END_DATE >= l_session_date