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