DBA Data[Home] [Help]

APPS.GHR_NFC_POSITION_EXTRACTS dependencies on GHR_POS_INTERFACE_ERR_DTLS

Line 3428: FROM ghr_pos_interface_err_dtls;

3424: susp_function_cd,
3425: record_id,
3426: result_dtl_id,
3427: result_id
3428: FROM ghr_pos_interface_err_dtls;
3429:
3430: CURSOR csr_chk_err_position
3431: (c_position_id IN NUMBER
3432: ,c_ext_rslt_id IN Number

Line 3495: l_err_position_id ghr_pos_interface_err_dtls.POSITION_ID%TYPE;

3491: l_val_tab ValTabTyp;
3492: l_ext_position_id NUMBER;
3493: l_ext_rslt_dtl_id ben_ext_rslt_dtl.ext_rslt_dtl_id%TYPE;
3494: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
3495: l_err_position_id ghr_pos_interface_err_dtls.POSITION_ID%TYPE;
3496: l_err_fuction_code ghr_pos_interface_err_dtls.susp_function_cd%TYPE;
3497: l_rcd_function_code varchar(2);
3498: l_sh_function_code varchar(2);
3499: l_result_dtl_id ben_ext_rslt_dtl.ext_rslt_dtl_id%TYPE;

Line 3496: l_err_fuction_code ghr_pos_interface_err_dtls.susp_function_cd%TYPE;

3492: l_ext_position_id NUMBER;
3493: l_ext_rslt_dtl_id ben_ext_rslt_dtl.ext_rslt_dtl_id%TYPE;
3494: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
3495: l_err_position_id ghr_pos_interface_err_dtls.POSITION_ID%TYPE;
3496: l_err_fuction_code ghr_pos_interface_err_dtls.susp_function_cd%TYPE;
3497: l_rcd_function_code varchar(2);
3498: l_sh_function_code varchar(2);
3499: l_result_dtl_id ben_ext_rslt_dtl.ext_rslt_dtl_id%TYPE;
3500: l_rslt_dtl_id NUMBER;