APPS.PQP_PENSION_EXTRACTS dependencies on BEN_EXT_RSLT_ERR

Line 1437: SELECT count(*) FROM ben_ext_rslt_err

1433: l_err_no NUMBER := p_err_no ;
1434: l_err_num NUMBER(15);
1435: --
1436: CURSOR err_cnt_c IS
1437: SELECT count(*) FROM ben_ext_rslt_err
1438: WHERE ext_rslt_id = ben_extract.g_ext_rslt_id
1439: AND typ_cd <> 'W';
1440: --
1441: BEGIN

Line 4473: FROM ben_ext_rslt_err err

4469: ,c_ext_rslt_id IN NUMBER) IS
4470: SELECT err.person_id
4471: ,err.typ_cd
4472: ,err.ext_rslt_id
4473: FROM ben_ext_rslt_err err
4474: WHERE err.business_group_id = c_bg_id
4475: AND err.typ_cd = 'E'
4476: AND err.ext_rslt_id = c_ext_rslt_id;
4477:

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

4535:
4536: -- =============================================================================
4537: -- Raise_Extract_Warning:
4538: -- When called from the Rule of a extract detail data element
4539: -- it logs a warning in the ben_ext_rslt_err table against
4540: -- the person being processed (or as specified by context of
4541: -- assignment id ). It prefixes all warning messages with a
4542: -- string "Warning raised in data element "||element_name
4543: -- This allows the same Rule to be called from different data