APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_TASKS

Line 1095: from pa_expenditure_items_all E, pa_tasks T

1091: /*Commented for bug 3088683
1092: SELECT 'Y' into lv_return_flag from dual
1093: where exists
1094: (select T.project_id
1095: from pa_expenditure_items_all E, pa_tasks T
1096: where T.project_id = p_project_id
1097: and E.task_id = T.task_id);
1098: End of comment for bug 3088683 */
1099:

Line 1240: pa_tasks t

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))
1244: OR ( t.emp_bill_rate_schedule_id = br.BILL_RATE_SCH_ID

Line 1251: FROM pa_projects p, pa_tasks t

1247: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))));
1248: */
1249: SELECT 'Y' INTO lv_return_flag FROM DUAL
1250: WHERE EXISTS (SELECT p.project_id
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

Line 1534: from pa_billing_assignments asg, pa_tasks t

1530:
1531: BEGIN
1532: SELECT 'Y' into lv_return_flag from dual
1533: where exists (select null
1534: from pa_billing_assignments asg, pa_tasks t
1535: where t.project_id = p_project_id
1536: /* and nvl(asg.top_task_id,-99) = t.task_id Bug 2702200 Modified on 20/12/2002 */
1537: and asg.top_task_id = t.task_id
1538: and asg.project_id = t.project_id -- added for bug 3517177

Line 1552: FROM pa_job_bill_rate_overrides jbr, pa_tasks t

1548:
1549: BEGIN
1550: SELECT 'Y' into lv_return_flag from dual
1551: where exists (select null
1552: FROM pa_job_bill_rate_overrides jbr, pa_tasks t
1553: where t.project_id = p_project_id
1554: /* and nvl(jbr.task_id,-99) = t.task_id Bug 2702200 Modified on 20/12/2002 */
1555: and jbr.task_id = t.task_id
1556: and jbr.task_id IS NOT NULL

Line 1569: FROM pa_nl_bill_rate_overrides nlr, pa_tasks t

1565:
1566: BEGIN
1567: SELECT 'Y' into lv_return_flag from dual
1568: where exists (select null
1569: FROM pa_nl_bill_rate_overrides nlr, pa_tasks t
1570: where t.project_id = p_project_id
1571: /* and nvl(nlr.task_id,-99) = t.task_id Modifed on 20/12/2002 */
1572: and nlr.task_id = t.task_id
1573: and nlr.task_id IS NOT NULL

Line 1587: FROM pa_emp_bill_rate_overrides emp, pa_tasks t

1583:
1584: BEGIN
1585: SELECT 'Y' into lv_return_flag from dual
1586: where exists (select null
1587: FROM pa_emp_bill_rate_overrides emp, pa_tasks t
1588: where t.project_id = p_project_id
1589: /* and nvl(emp.task_id,-99) = t.task_id Modifed on 20/12/2002*/
1590: and emp.task_id = t.task_id
1591: and emp.task_id IS NOT NULL

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),