DBA Data[Home] [Help]

APPS.PQP_PROFESSIONAL_BODY_FUNCTION dependencies on PER_QUALIFICATIONS

Line 135: FROM per_qualifications qua

131: CURSOR csr_get_pb_mem_info (c_professional_body_nm IN VARCHAR2)
132: IS
133: SELECT qua.professional_body_name
134: ,qua.membership_category
135: FROM per_qualifications qua
136: WHERE qua.person_id = l_person_id
137: AND qua.professional_body_name = c_professional_body_nm
138: AND nvl(qua.business_group_id, p_business_group_id)
139: = p_business_group_id