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

Line 1143: FROM pa_project_types ppt, pa_std_bill_rate_schedules brs

1139: SELECT ppt.baseline_funding_flag
1140: ,ppt.NON_LAB_STD_BILL_RT_SCH_ID
1141: ,brs.std_bill_rate_schedule
1142: ,brs.rate_sch_currency_code
1143: FROM pa_project_types ppt, pa_std_bill_rate_schedules brs
1144: WHERE ppt.project_type = p_project_type
1145: AND ppt.non_lab_std_bill_rt_sch_id = brs.bill_rate_sch_id(+);
1146:
1147: BEGIN

Line 1201: FROM pa_std_bill_rate_schedules_all br, pa_project_types p

1197: BEGIN
1198:
1199: SELECT 'Y' INTO lv_return_flag FROM DUAL
1200: WHERE EXISTS (SELECT p.project_type_id
1201: FROM pa_std_bill_rate_schedules_all br, pa_project_types p
1202: WHERE ( p.job_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1203: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))
1204: OR ( p.emp_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1205: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))

Line 1219: FROM pa_std_bill_rate_schedules_all br, pa_projects p

1215: BEGIN
1216:
1217: SELECT 'Y' INTO lv_return_flag FROM DUAL
1218: WHERE EXISTS (SELECT p.project_id
1219: FROM pa_std_bill_rate_schedules_all br, pa_projects p
1220: WHERE ( p.job_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1221: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))
1222: OR ( p.emp_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1223: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))

Line 1239: FROM pa_std_bill_rate_schedules_all br, pa_projects p,

1235: /* Fix for Performance bug 4939354
1236:
1237: SELECT 'Y' INTO lv_return_flag FROM DUAL
1238: WHERE EXISTS (SELECT p.project_id
1239: FROM pa_std_bill_rate_schedules_all br, pa_projects p,
1240: pa_tasks t
1241: WHERE p.project_id = t.project_id
1242: AND ( ( t.job_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1243: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))

Line 1255: FROM pa_std_bill_rate_schedules_all br

1251: FROM pa_projects p, pa_tasks t
1252: WHERE p.project_id = t.project_id
1253: AND EXISTS
1254: (select null
1255: FROM pa_std_bill_rate_schedules_all br
1256: WHERE ( (t.job_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1257: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))
1258: OR ( t.emp_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1259: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))

Line 1419: FROM pa_std_bill_rate_schedules b

1415: /* Commented for bug 2867740
1416: FROM pa_bill_rates b
1417: WHERE b.RATE_CURRENCY_CODE <> pa_currency.get_currency_code); */
1418: /* Bug fix for bug 2867740 Starts Here */
1419: FROM pa_std_bill_rate_schedules b
1420: WHERE b.RATE_SCH_CURRENCY_CODE <> pa_currency.get_currency_code);
1421: /* Bug fix for bug 2867740 Ends Here */
1422: RETURN (lv_return_flag);
1423: EXCEPTION

Line 1514: FROM PA_STD_BILL_RATE_SCHEDULES_all br, pa_projects p

1510:
1511: BEGIN
1512: SELECT 'Y' into lv_return_flag from dual
1513: where exists (select null
1514: FROM PA_STD_BILL_RATE_SCHEDULES_all br, pa_projects p
1515: where p.project_id = p_project_id
1516: and br.BILL_RATE_SCH_ID in
1517: (nvl(p.job_bill_rate_schedule_id,-99),
1518: nvl(p.emp_bill_rate_schedule_id,-99),

Line 1605: FROM PA_STD_BILL_RATE_SCHEDULES_all br, pa_tasks t

1601:
1602: BEGIN
1603: SELECT 'Y' into lv_return_flag from dual
1604: where exists (select null
1605: FROM PA_STD_BILL_RATE_SCHEDULES_all br, pa_tasks t
1606: where t.project_id = p_project_id
1607: and br.BILL_RATE_SCH_ID in
1608: (nvl(t.job_bill_rate_schedule_id,-99),
1609: nvl(t.emp_bill_rate_schedule_id,-99),