4955: INSERT INTO po_session_gt(key, num1, num2)
4956: SELECT p_key,
4957: p_index_tbl(i),
4958: business_group_id
4959: FROM per_business_groups_perf
4960: WHERE p_job_business_group_name_tbl(i) IS NOT NULL
4961: AND x_job_business_group_id_tbl(i) IS NULL
4962: AND name = p_job_business_group_name_tbl(i)
4963: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(date_from, sysdate))
5154: p_index_tbl(i),
5155: jobs_b.job_id
5156: FROM per_jobs jobs_b,
5157: per_jobs_tl jobs_tl,
5158: per_business_groups_perf groups
5159: WHERE p_job_name_tbl(i) IS NOT NULL
5160: AND x_job_id_tbl(i) IS NULL
5161: AND x_job_business_group_id_tbl(i) IS NOT NULL
5162: AND jobs_b.job_id = jobs_tl.job_id