DBA Data[Home] [Help]

APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on PER_QUALIFICATIONS_V

Line 481: FROM per_qualifications_v pq

477: ,p_memb_type IN VARCHAR2
478: ) IS
479:
480: SELECT membership_number
481: FROM per_qualifications_v pq
482: WHERE pq.person_id = p_person_id
483: AND pq.business_group_id = p_business_group_id
484: AND p_effective_date
485: BETWEEN NVL(pq.start_date,p_effective_date)