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.PA_MULTI_CURRENCY_BILLING dependencies on PA_STD_BILL_RATE_SCHEDULES_ALL

Line 1208: FROM pa_std_bill_rate_schedules_all br, pa_project_types p

1204: BEGIN
1205:
1206: SELECT 'Y' INTO lv_return_flag FROM DUAL
1207: WHERE EXISTS (SELECT p.project_type_id
1208: FROM pa_std_bill_rate_schedules_all br, pa_project_types p
1209: WHERE ( p.job_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1210: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))
1211: OR ( p.emp_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1212: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))

Line 1226: FROM pa_std_bill_rate_schedules_all br, pa_projects p

1222: BEGIN
1223:
1224: SELECT 'Y' INTO lv_return_flag FROM DUAL
1225: WHERE EXISTS (SELECT p.project_id
1226: FROM pa_std_bill_rate_schedules_all br, pa_projects p
1227: WHERE ( p.job_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1228: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))
1229: OR ( p.emp_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1230: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))

Line 1246: FROM pa_std_bill_rate_schedules_all br, pa_projects p,

1242: /* Fix for Performance bug 4939354
1243:
1244: SELECT 'Y' INTO lv_return_flag FROM DUAL
1245: WHERE EXISTS (SELECT p.project_id
1246: FROM pa_std_bill_rate_schedules_all br, pa_projects p,
1247: pa_tasks t
1248: WHERE p.project_id = t.project_id
1249: AND ( ( t.job_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1250: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))

Line 1262: FROM pa_std_bill_rate_schedules_all br

1258: FROM pa_projects p, pa_tasks t
1259: WHERE p.project_id = t.project_id
1260: AND EXISTS
1261: (select null
1262: FROM pa_std_bill_rate_schedules_all br
1263: WHERE ( (t.job_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1264: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))
1265: OR ( t.emp_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1266: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))

Line 1521: FROM PA_STD_BILL_RATE_SCHEDULES_all br, pa_projects p

1517:
1518: BEGIN
1519: SELECT 'Y' into lv_return_flag from dual
1520: where exists (select null
1521: FROM PA_STD_BILL_RATE_SCHEDULES_all br, pa_projects p
1522: where p.project_id = p_project_id
1523: and br.BILL_RATE_SCH_ID in
1524: (nvl(p.job_bill_rate_schedule_id,-99),
1525: nvl(p.emp_bill_rate_schedule_id,-99),

Line 1612: FROM PA_STD_BILL_RATE_SCHEDULES_all br, pa_tasks t

1608:
1609: BEGIN
1610: SELECT 'Y' into lv_return_flag from dual
1611: where exists (select null
1612: FROM PA_STD_BILL_RATE_SCHEDULES_all br, pa_tasks t
1613: where t.project_id = p_project_id
1614: and br.BILL_RATE_SCH_ID in
1615: (nvl(t.job_bill_rate_schedule_id,-99),
1616: nvl(t.emp_bill_rate_schedule_id,-99),