APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on BEN_EXT_RSLT_DTL

Line 197: ben_ext_rslt_dtl rdtl

193: TRUNC (rslt.eff_dt)
194: ) -- highest effective date of all prev runs
195: FROM pqp_extract_attributes pqea,
196: ben_ext_rslt rslt,
197: ben_ext_rslt_dtl rdtl
198: -- ben_ext_rcd drcd
199: WHERE pqea.ext_dfn_type = g_extract_type
200: AND rslt.ext_dfn_id = pqea.ext_dfn_id
201: AND rslt.business_group_id = g_business_group_id

Line 231: ben_ext_rslt_dtl rdtl

227: TRUNC (rslt.eff_dt)
228: ) -- least effective date of all future runs
229: FROM pqp_extract_attributes pqea,
230: ben_ext_rslt rslt,
231: ben_ext_rslt_dtl rdtl
232: -- ben_ext_rcd drcd
233: WHERE pqea.ext_dfn_type = g_extract_type
234: AND rslt.ext_dfn_id = pqea.ext_dfn_id
235: AND rslt.business_group_id = g_business_group_id

Line 4199: FROM ben_ext_rslt_dtl dtl

4195: CURSOR count_extract_details
4196: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)
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

Line 4290: FROM ben_ext_rslt_dtl dtl

4286: 42, VAL_42,
4287: 44, VAL_44
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