APPS.QPR_USER_PLAN_INIT_PVT dependencies on QPR_REPORT_TYPE_HDRS_B

Line 199: * fetch all data from QPR_REPORT_TYPE_HDRS_B

195: x_return_status OUT NOCOPY VARCHAR2
196: ) is
197: BEGIN
198: /*
199: * fetch all data from QPR_REPORT_TYPE_HDRS_B
200: * for user_id=null and plan_id=null
201: */
202: /*
203: * Check for a report entity for that user_id and plan_id and

Line 250: from QPR_REPORT_TYPE_HDRS_B rth

246: ,null
247: ,null
248: ,null
249: ,null
250: from QPR_REPORT_TYPE_HDRS_B rth
251: where
252: rth.user_id is null
253: and rth.plan_id is null
254: and not exists

Line 384: from QPR_REPORT_TYPE_HDRS_B rth

380: update qpr_report_lines rl
381: set report_line_valid_flag = G_REPORT_REFRESH_FLAG
382: where rl.report_header_id in
383: (select report_header_id
384: from QPR_REPORT_TYPE_HDRS_B rth
385: where rth.user_id = p_user_id
386: and rth.plan_id = p_plan_id
387: );--}
388: else--{