DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PER_BUSINESS_GROUPS_PERF

Line 4037: FROM per_business_groups_perf

4033: INSERT INTO po_session_gt(key, num1, num2)
4034: SELECT p_key,
4035: p_index_tbl(i),
4036: business_group_id
4037: FROM per_business_groups_perf
4038: WHERE p_job_business_group_name_tbl(i) IS NOT NULL
4039: AND x_job_business_group_id_tbl(i) IS NULL
4040: AND name = p_job_business_group_name_tbl(i)
4041: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(date_from, sysdate))

Line 4236: per_business_groups_perf groups

4232: p_index_tbl(i),
4233: jobs_b.job_id
4234: FROM per_jobs jobs_b,
4235: per_jobs_tl jobs_tl,
4236: per_business_groups_perf groups
4237: WHERE p_job_name_tbl(i) IS NOT NULL
4238: AND x_job_id_tbl(i) IS NULL
4239: AND x_job_business_group_id_tbl(i) IS NOT NULL
4240: AND jobs_b.job_id = jobs_tl.job_id