APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on BEN_EXT_THREAD

Line 4201: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id

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

Line 4292: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id

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

Line 4304: l_rslt_id NUMBER := ben_ext_thread.g_ext_rslt_id;

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