APPS.PQP_NL_ABP_FUNCTIONS dependencies on BEN_EXT_RSLT_DTL

Line 45: AND EXISTS ( SELECT 1 FROM ben_ext_rslt_dtl dtl

41: WHERE ext_dfn_id IN (SELECT ext_dfn_id
42: FROM pqp_extract_attributes
43: WHERE ext_dfn_type = 'NL_FPR')
44: AND ext_stat_cd = 'A'
45: AND EXISTS ( SELECT 1 FROM ben_ext_rslt_dtl dtl
46: WHERE dtl.ext_rslt_id = res.ext_rslt_id
47: AND dtl.person_id = p_person_id)
48: ORDER BY ext_rslt_id DESC;
49:

Line 103: AND EXISTS ( SELECT 1 FROM ben_ext_rslt_dtl dtl

99: WHERE ext_dfn_id IN (SELECT ext_dfn_id
100: FROM pqp_extract_attributes
101: WHERE ext_dfn_type = 'NL_FPR')
102: AND ext_stat_cd = 'A'
103: AND EXISTS ( SELECT 1 FROM ben_ext_rslt_dtl dtl
104: WHERE dtl.ext_rslt_id = res.ext_rslt_id
105: AND dtl.person_id = p_person_id)
106: ORDER BY ext_rslt_id DESC;
107: