APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on BEN_EXT_THREAD

Line 4202: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id

4198: IS
4199: SELECT COUNT (*)
4200: FROM ben_ext_rslt_dtl dtl
4201: -- ,ben_ext_rcd rcd
4202: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
4203: AND dtl.ext_rcd_id = p_ext_rcd_id
4204: -- AND rcd.ext_rcd_id = dtl.ext_rcd_id
4205: -- AND rcd.rcd_type_cd = 'D'
4206: AND DECODE (

Line 4293: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id

4289: )
4290: )), 0) total_value
4291: FROM ben_ext_rslt_dtl dtl
4292: -- ,ben_ext_rcd rcd
4293: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
4294: AND dtl.ext_rcd_id = p_ext_rcd_id;
4295: -- AND rcd.ext_rcd_id = dtl.ext_rcd_id
4296: -- AND rcd.rcd_type_cd = 'D';
4297:

Line 4305: l_rslt_id NUMBER := ben_ext_thread.g_ext_rslt_id;

4301:
4302: -- TYPE ref_get_total IS REF CURSOR;
4303:
4304: -- csr_get_total ref_get_total;
4305: l_rslt_id NUMBER := ben_ext_thread.g_ext_rslt_id;
4306: l_total_value NUMBER := 0;
4307: l_fmt_total_value VARCHAR2 (12);
4308: l_val_seq VARCHAR2 (100);
4309: l_ext_rcd_id NUMBER;