APPS.PQP_US_PENSION_EXTRACTS dependencies on BEN_EXT_RSLT_ERR

Line 2251: SELECT count(*) FROM ben_ext_rslt_err

2247: l_err_no NUMBER := p_err_no ;
2248: l_err_num NUMBER(15);
2249: --
2250: CURSOR err_cnt_c IS
2251: SELECT count(*) FROM ben_ext_rslt_err
2252: WHERE ext_rslt_id = ben_extract.g_ext_rslt_id
2253: AND typ_cd <> 'W';
2254: --
2255: BEGIN

Line 5294: FROM ben_ext_rslt_err err

5290: ,c_ext_rslt_id IN NUMBER) IS
5291: SELECT err.person_id
5292: ,err.typ_cd
5293: ,err.ext_rslt_id
5294: FROM ben_ext_rslt_err err
5295: WHERE err.business_group_id = c_bg_id
5296: AND err.typ_cd = 'E'
5297: AND err.ext_rslt_id = c_ext_rslt_id;
5298: l_ben_params csr_ben%ROWTYPE;

Line 5357: -- it logs a warning in the ben_ext_rslt_err table against

5353:
5354: -- ====================================================================
5355: -- Raise_Extract_Warning:
5356: -- When called from the Rule of a extract detail data element
5357: -- it logs a warning in the ben_ext_rslt_err table against
5358: -- the person being processed (or as specified by context of
5359: -- assignment id ). It prefixes all warning messages with a
5360: -- string "Warning raised in data element "||element_name
5361: -- This allows the same Rule to be called from different data