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 295: -- get the ben_ext_rcd.ext_rcd_id

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

Line 4196: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)

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

Line 4200: -- ,ben_ext_rcd rcd

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

Line 4223: -- get the ben_ext_rcd.ext_rcd_id

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

Line 4276: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)

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

Line 4291: -- ,ben_ext_rcd rcd

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

Line 4329: -- get the ben_ext_rcd.ext_rcd_id

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