DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PER_BUSINESS_GROUPS_PERF

Line 4959: FROM per_business_groups_perf

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))

Line 5158: per_business_groups_perf groups

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