APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_TASKS

Line 1102: from pa_expenditure_items_all E, pa_tasks T

1098: /*Commented for bug 3088683
1099: SELECT 'Y' into lv_return_flag from dual
1100: where exists
1101: (select T.project_id
1102: from pa_expenditure_items_all E, pa_tasks T
1103: where T.project_id = p_project_id
1104: and E.task_id = T.task_id);
1105: End of comment for bug 3088683 */
1106:

Line 1247: pa_tasks t

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

Line 1258: FROM pa_projects p, pa_tasks t

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

Line 1541: from pa_billing_assignments asg, pa_tasks t

1537:
1538: BEGIN
1539: SELECT 'Y' into lv_return_flag from dual
1540: where exists (select null
1541: from pa_billing_assignments asg, pa_tasks t
1542: where t.project_id = p_project_id
1543: /* and nvl(asg.top_task_id,-99) = t.task_id Bug 2702200 Modified on 20/12/2002 */
1544: and asg.top_task_id = t.task_id
1545: and asg.project_id = t.project_id -- added for bug 3517177

Line 1559: FROM pa_job_bill_rate_overrides jbr, pa_tasks t

1555:
1556: BEGIN
1557: SELECT 'Y' into lv_return_flag from dual
1558: where exists (select null
1559: FROM pa_job_bill_rate_overrides jbr, pa_tasks t
1560: where t.project_id = p_project_id
1561: /* and nvl(jbr.task_id,-99) = t.task_id Bug 2702200 Modified on 20/12/2002 */
1562: and jbr.task_id = t.task_id
1563: and jbr.task_id IS NOT NULL

Line 1576: FROM pa_nl_bill_rate_overrides nlr, pa_tasks t

1572:
1573: BEGIN
1574: SELECT 'Y' into lv_return_flag from dual
1575: where exists (select null
1576: FROM pa_nl_bill_rate_overrides nlr, pa_tasks t
1577: where t.project_id = p_project_id
1578: /* and nvl(nlr.task_id,-99) = t.task_id Modifed on 20/12/2002 */
1579: and nlr.task_id = t.task_id
1580: and nlr.task_id IS NOT NULL

Line 1594: FROM pa_emp_bill_rate_overrides emp, pa_tasks t

1590:
1591: BEGIN
1592: SELECT 'Y' into lv_return_flag from dual
1593: where exists (select null
1594: FROM pa_emp_bill_rate_overrides emp, pa_tasks t
1595: where t.project_id = p_project_id
1596: /* and nvl(emp.task_id,-99) = t.task_id Modifed on 20/12/2002*/
1597: and emp.task_id = t.task_id
1598: and emp.task_id IS NOT NULL

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