DBA Data[Home] [Help]

APPS.GHR_US_NFC_EXTRACTS dependencies on BEN_EXT_RSLT_ERR

Line 2332: select count(*) from ben_ext_rslt_err

2328: l_err_no number;
2329: l_err_num number(15);
2330: --
2331: cursor err_cnt_c is
2332: select count(*) from ben_ext_rslt_err
2333: where ext_rslt_id = ben_extract.g_ext_rslt_id
2334: and typ_cd <> 'W';
2335: --
2336: begin

Line 2496: from ben_ext_rslt_err err

2492: ,c_ext_rslt_id in number) is
2493: select err.person_id
2494: ,err.typ_cd
2495: ,err.ext_rslt_id
2496: from ben_ext_rslt_err err
2497: where err.business_group_id = c_bg_id
2498: and err.typ_cd = 'E'
2499: and err.ext_rslt_id = c_ext_rslt_id;
2500: