eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_LINES_SV7 dependencies on PER_JOBS_VL

Line 1508: FROM PER_JOBS_VL PJ,

1504: END IF;
1505:
1506: SELECT COUNT(PJ.job_id)
1507: INTO x_count
1508: FROM PER_JOBS_VL PJ,
1509: FINANCIALS_SYSTEM_PARAMETERS FSP
1510: WHERE PJ.job_id = p_job_id
1511: AND PJ.business_group_id = FSP.business_group_id
1512: AND FSP.business_group_id = NVL(p_job_business_group_id,

Line 1525: FROM PER_JOBS_VL PJ,

1521: END IF;
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

Line 1581: PER_JOBS_VL PJ

1577: --job should be Valid for the Purchasing category
1578: SELECT COUNT(*)
1579: INTO x_count
1580: FROM PO_JOB_ASSOCIATIONS_B PJA,
1581: PER_JOBS_VL PJ
1582: WHERE PJA.job_id = p_job_id
1583: AND PJA.category_id = x_category_id
1584: AND PJA.job_id = PJ.job_id
1585: AND NVL(TRUNC(PJA.inactive_date), TRUNC(sysdate)) >= TRUNC(sysdate)