APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on PQP_EXT_CROSS_PERSON_RECORDS

Line 511: -- pqp_ext_cross_person_records

507: AND pq.name = p_memb_type;
508:
509:
510: -- This cursor returns the lea_number from
511: -- pqp_ext_cross_person_records
512: -- a) M - Master Bg Id
513: CURSOR csr_lea_number
514: IS
515: SELECT lea_number

Line 516: FROM pqp_ext_cross_person_records emd

512: -- a) M - Master Bg Id
513: CURSOR csr_lea_number
514: IS
515: SELECT lea_number
516: FROM pqp_ext_cross_person_records emd
517: WHERE emd.record_type = 'M'
518: AND emd.ext_dfn_id = ben_ext_thread.g_ext_dfn_id --ENH4
519: AND emd.request_id = g_parent_request_id ;
520: --