APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on BEN_EXT_RSLT

Line 196: ben_ext_rslt rslt,

192: SELECT MAX (
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

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 230: ben_ext_rslt rslt,

226: SELECT MIN (
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

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 4200: FROM ben_ext_rslt_dtl dtl

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

Line 4291: FROM ben_ext_rslt_dtl dtl

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