DBA Data[Home] [Help]

APPS.PO_LINES_SV7 dependencies on PER_BUSINESS_GROUPS_PERF

Line 1412: FROM PER_BUSINESS_GROUPS_PERF PBG

1408: END IF;
1409:
1410: SELECT COUNT(PBG.business_group_id)
1411: INTO x_count
1412: FROM PER_BUSINESS_GROUPS_PERF PBG
1413: WHERE PBG.business_group_id = p_job_business_group_id
1414: AND TRUNC(sysdate) BETWEEN NVL(TRUNC(PBG.date_from), TRUNC(sysdate))
1415: AND NVL(TRUNC(PBG.date_to), TRUNC(sysdate));
1416:

Line 1526: PER_BUSINESS_GROUPS_PERF PBG

1522:
1523: SELECT COUNT(PJ.job_id)
1524: INTO x_count
1525: FROM PER_JOBS_VL PJ,
1526: PER_BUSINESS_GROUPS_PERF PBG
1527: WHERE PJ.job_id = p_job_id
1528: AND PJ.business_group_id = p_job_business_group_id
1529: AND PJ.business_group_id = PBG.business_group_id
1530: AND TRUNC(sysdate) BETWEEN NVL(TRUNC(PJ.date_from), TRUNC(sysdate))