APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on BEN_EXT_RCD

Line 190: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)

186: --
187: -- Modified cursor for performance fix
188:
189: CURSOR csr_last_run_details
190: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)
191: IS
192: SELECT MAX (
193: TRUNC (rslt.eff_dt)
194: ) -- highest effective date of all prev runs

Line 198: -- ben_ext_rcd drcd

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
202: AND rslt.ext_stat_cd NOT IN ('F' -- Job Failure

Line 224: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)

220: )
221: AND rslt.eff_dt < g_effective_date;
222:
223: CURSOR csr_next_run_details
224: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)
225: IS
226: SELECT MIN (
227: TRUNC (rslt.eff_dt)
228: ) -- least effective date of all future runs

Line 232: -- ben_ext_rcd drcd

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
236: AND rdtl.ext_rslt_id = rslt.ext_rslt_id

Line 296: -- get the ben_ext_rcd.ext_rcd_id

292: 'g_effective_end_date: '
293: || fnd_date.date_to_canonical (g_effective_end_date)
294: );
295: -- 11.5.10_CU2: Performance fix :
296: -- get the ben_ext_rcd.ext_rcd_id
297: -- and use this one for next cursor
298: -- This will prevent FTS on the table.
299:
300: OPEN csr_ext_rcd_id (p_hide_flag => 'Y'

Line 4197: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)

4193: := g_proc_name
4194: || 'get_total_number_data_records';
4195:
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

Line 4201: -- ,ben_ext_rcd rcd

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
4205: -- AND rcd.rcd_type_cd = 'D'

Line 4224: -- get the ben_ext_rcd.ext_rcd_id

4220: debug_enter (l_proc_name);
4221: --
4222:
4223: -- 11.5.10_CU2: Performance fix :
4224: -- get the ben_ext_rcd.ext_rcd_id
4225: -- and use this one for next cursor
4226: -- This will prevent FTS on the table.
4227:
4228: OPEN csr_ext_rcd_id (p_hide_flag => 'N'

Line 4277: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)

4273: -- please include additional sequence values
4274: -- if you use any of them
4275:
4276: CURSOR csr_get_total
4277: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)
4278: IS
4279: SELECT NVL (SUM (TO_NUMBER(DECODE (p_val_seq,
4280: 23, VAL_23,
4281: 25, VAL_25,

Line 4292: -- ,ben_ext_rcd rcd

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
4296: -- AND rcd.rcd_type_cd = 'D';

Line 4330: -- get the ben_ext_rcd.ext_rcd_id

4326: --
4327: -- l_val_seq := 'dtl.val_'
4328: -- || l_val_seq;
4329: -- 11.5.10_CU2: Performance fix :
4330: -- get the ben_ext_rcd.ext_rcd_id
4331: -- and use this one for next cursor
4332: -- This will prevent FTS on the table.
4333:
4334: OPEN csr_ext_rcd_id (p_hide_flag => 'N'