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.GMS_BILLING dependencies on PA_TASKS

Line 228: pa_tasks t3,

224: from dual
225: where exists(
226: select /*+ INDEX(adl gms_award_distributions_n7) */ 1 /* Added hint for bug 6969435 */
227: from gms_award_distributions adl,
228: pa_tasks t3,
229: pa_tasks t5
230: where adl.award_id = X_Award_Id
231: and adl.document_type = 'EXP'
232: and adl.adl_status = 'A'

Line 229: pa_tasks t5

225: where exists(
226: select /*+ INDEX(adl gms_award_distributions_n7) */ 1 /* Added hint for bug 6969435 */
227: from gms_award_distributions adl,
228: pa_tasks t3,
229: pa_tasks t5
230: where adl.award_id = X_Award_Id
231: and adl.document_type = 'EXP'
232: and adl.adl_status = 'A'
233: and adl.fc_status = 'A'

Line 274: pa_tasks t3,

270: where exists(
271: select /*+ INDEX(adl gms_award_distributions_n7) */ 1 /* Added hint for bug 6969435 */
272: from
273: gms_award_distributions adl,
274: pa_tasks t3,
275: pa_tasks t5
276: where adl.award_id = X_Award_Id
277: and adl.document_type = 'EXP'
278: and adl.adl_status = 'A'

Line 275: pa_tasks t5

271: select /*+ INDEX(adl gms_award_distributions_n7) */ 1 /* Added hint for bug 6969435 */
272: from
273: gms_award_distributions adl,
274: pa_tasks t3,
275: pa_tasks t5
276: where adl.award_id = X_Award_Id
277: and adl.document_type = 'EXP'
278: and adl.adl_status = 'A'
279: and adl.fc_status = 'A'

Line 675: from PA_TASKS t

671: WHERE project_id = f_act_project_id
672: AND ( task_id IS NULL
673: OR task_id = f_act_task_id
674: OR task_id = (select t.top_task_id
675: from PA_TASKS t
676: where t.task_id = f_act_task_id)
677: )
678: AND installment_id = f_installment_id;
679:

Line 689: from PA_TASKS t

685: WHERE project_id = f_act_project_id
686: AND ( task_id IS NULL
687: OR task_id = f_act_task_id
688: OR task_id = (select t.top_task_id
689: from PA_TASKS t
690: where t.task_id = f_act_task_id)
691: )
692: AND installment_id = f_installment_id;
693:

Line 1003: pa_tasks t3,

999: from pa_expenditure_items_all ei,
1000: pa_expenditure_types et,
1001: pa_projects_all p,
1002: pa_project_types pt,
1003: pa_tasks t3,
1004: pa_tasks t5,
1005: gms_award_distributions adl
1006: where adl.award_id = X_Award_Id
1007: and ei.expenditure_item_id = adl.expenditure_item_id

Line 1004: pa_tasks t5,

1000: pa_expenditure_types et,
1001: pa_projects_all p,
1002: pa_project_types pt,
1003: pa_tasks t3,
1004: pa_tasks t5,
1005: gms_award_distributions adl
1006: where adl.award_id = X_Award_Id
1007: and ei.expenditure_item_id = adl.expenditure_item_id
1008: and ei.system_linkage_function <> 'BTC'

Line 1200: from PA_TASKS t

1196: WHERE project_id = x_actual_project_id
1197: AND ( task_id IS NULL
1198: OR task_id = x_task_id
1199: OR task_id = (select t.top_task_id
1200: from PA_TASKS t
1201: where t.task_id = x_task_id)
1202: )
1203: AND installment_id = X_ei_rollback_inst_tab(i).installment_id ;
1204:

Line 1286: OR (gmf.task_id = (select t.top_task_id from PA_TASKS t where t.task_id = X_Task_Id))

1282: )
1283: and (
1284: (gmf.task_id = X_Task_Id)
1285: OR (gmf.task_id is NULL)
1286: OR (gmf.task_id = (select t.top_task_id from PA_TASKS t where t.task_id = X_Task_Id))
1287: )
1288: and gmf.project_id = (select project_id from PA_TASKS where task_id = X_Task_Id);
1289:
1290:

Line 1288: and gmf.project_id = (select project_id from PA_TASKS where task_id = X_Task_Id);

1284: (gmf.task_id = X_Task_Id)
1285: OR (gmf.task_id is NULL)
1286: OR (gmf.task_id = (select t.top_task_id from PA_TASKS t where t.task_id = X_Task_Id))
1287: )
1288: and gmf.project_id = (select project_id from PA_TASKS where task_id = X_Task_Id);
1289:
1290:
1291: --t.task_id = decode(gmf.task_id,null,t.task_id,gmf.task_id);
1292:

Line 1388: pa_tasks t3,

1384: adl.award_id
1385: from pa_expenditure_items_all ei,
1386: pa_projects_all p,
1387: pa_project_types pt,
1388: pa_tasks t3,
1389: pa_tasks t5,
1390: gms_award_distributions adl
1391: where adl.award_id = X_Award_Id
1392: and ei.expenditure_item_id = adl.expenditure_item_id

Line 1389: pa_tasks t5,

1385: from pa_expenditure_items_all ei,
1386: pa_projects_all p,
1387: pa_project_types pt,
1388: pa_tasks t3,
1389: pa_tasks t5,
1390: gms_award_distributions adl
1391: where adl.award_id = X_Award_Id
1392: and ei.expenditure_item_id = adl.expenditure_item_id
1393: and ei.system_linkage_function <> 'BTC'

Line 1638: OR (gmf.task_id = (select t.top_task_id from PA_TASKS t where t.task_id = X_Task_Id))

1634: and (gmf.total_funding_amount - decode(X_Calling_Process,'Invoice',nvl(gmf.total_billed_amount,0),
1635: 'Revenue',nvl(gmf.total_revenue_amount,0) )) >0
1636: and ((gmf.task_id = X_Task_Id)
1637: OR (gmf.task_id is NULL)
1638: OR (gmf.task_id = (select t.top_task_id from PA_TASKS t where t.task_id = X_Task_Id))
1639: )
1640: and gmf.project_id = (select project_id from PA_TASKS where task_id = X_Task_Id)
1641: and ins.installment_id <> X_Installment_id
1642: order by ins.end_date_active;

Line 1640: and gmf.project_id = (select project_id from PA_TASKS where task_id = X_Task_Id)

1636: and ((gmf.task_id = X_Task_Id)
1637: OR (gmf.task_id is NULL)
1638: OR (gmf.task_id = (select t.top_task_id from PA_TASKS t where t.task_id = X_Task_Id))
1639: )
1640: and gmf.project_id = (select project_id from PA_TASKS where task_id = X_Task_Id)
1641: and ins.installment_id <> X_Installment_id
1642: order by ins.end_date_active;
1643:
1644: Begin

Line 2665: OR (gmf.task_id = (select t.top_task_id from PA_TASKS t where t.task_id = X_Task_Id))

2661: gmf.installment_id = C_Installment_Id
2662: and (
2663: (gmf.task_id = X_Task_Id)
2664: OR (gmf.task_id is NULL)
2665: OR (gmf.task_id = (select t.top_task_id from PA_TASKS t where t.task_id = X_Task_Id))
2666: )
2667: and gmf.project_id = (select project_id from PA_TASKS where task_id = X_Task_Id);
2668: RETURN FALSE;
2669: EXCEPTION

Line 2667: and gmf.project_id = (select project_id from PA_TASKS where task_id = X_Task_Id);

2663: (gmf.task_id = X_Task_Id)
2664: OR (gmf.task_id is NULL)
2665: OR (gmf.task_id = (select t.top_task_id from PA_TASKS t where t.task_id = X_Task_Id))
2666: )
2667: and gmf.project_id = (select project_id from PA_TASKS where task_id = X_Task_Id);
2668: RETURN FALSE;
2669: EXCEPTION
2670: WHEN NO_DATA_FOUND THEN
2671: RETURN TRUE;

Line 3222: or (spf.TASK_ID = (select t.top_task_id from PA_TASKS t where

3218: spf.INSTALLMENT_ID = X_Installment_Id
3219: and (
3220: (spf.TASK_ID = X_Task_Id)
3221: or (spf.TASK_ID IS NULL)
3222: or (spf.TASK_ID = (select t.top_task_id from PA_TASKS t where
3223: t.task_id = X_Task_Id))
3224: )
3225: and PROJECT_ID = (select project_id from pa_tasks where task_id = X_Task_Id);
3226:

Line 3225: and PROJECT_ID = (select project_id from pa_tasks where task_id = X_Task_Id);

3221: or (spf.TASK_ID IS NULL)
3222: or (spf.TASK_ID = (select t.top_task_id from PA_TASKS t where
3223: t.task_id = X_Task_Id))
3224: )
3225: and PROJECT_ID = (select project_id from pa_tasks where task_id = X_Task_Id);
3226:
3227: --DECODE(TASK_ID,NULL,X_Task_Id,TASK_ID) = X_Task_Id
3228:
3229: Elsif X_Calling_Process = 'Revenue' then

Line 3242: or (spf.TASK_ID = (select t.top_task_id from PA_TASKS t where

3238: spf.INSTALLMENT_ID = X_Installment_Id
3239: and (
3240: (spf.TASK_ID = X_Task_Id)
3241: or (spf.TASK_ID IS NULL)
3242: or (spf.TASK_ID = (select t.top_task_id from PA_TASKS t where
3243: t.task_id = X_Task_Id))
3244: )
3245: and PROJECT_ID = (select project_id from pa_tasks where task_id = X_Task_Id);
3246:

Line 3245: and PROJECT_ID = (select project_id from pa_tasks where task_id = X_Task_Id);

3241: or (spf.TASK_ID IS NULL)
3242: or (spf.TASK_ID = (select t.top_task_id from PA_TASKS t where
3243: t.task_id = X_Task_Id))
3244: )
3245: and PROJECT_ID = (select project_id from pa_tasks where task_id = X_Task_Id);
3246:
3247: --DECODE(TASK_ID,NULL,X_Task_Id,TASK_ID) = X_Task_Id
3248:
3249:

Line 4128: pa_tasks b,

4124: Ins_Act_Task_Num,
4125: Ins_Exp_Org_Name
4126: from
4127: pa_projects_all a,
4128: pa_tasks b,
4129: hr_organization_units c
4130: where a.project_id = Ins_Actual_Project_Id and
4131: b.task_id = Ins_Actual_Task_Id and
4132: c.organization_id = Ins_Expenditure_Org_Id;

Line 4410: pa_tasks b,

4406: Ins_Act_Task_Num,
4407: Ins_Exp_Org_Name
4408: from
4409: pa_projects_all a,
4410: pa_tasks b,
4411: hr_organization_units c
4412: where a.project_id = X_Act_Project_Id and
4413: b.task_id = X_Task_Id and
4414: c.organization_id = X_Expenditure_Org_Id;

Line 5532: ,pa_tasks t3

5528: ,pa_expenditure_types et
5529: ,pa_lookups unit
5530: ,pa_projects_all p
5531: ,pa_project_types pt
5532: ,pa_tasks t3
5533: ,pa_tasks t5
5534: where
5535: adl.award_id = X_Award_Id
5536: and ei.expenditure_item_id = adl.expenditure_item_id

Line 5533: ,pa_tasks t5

5529: ,pa_lookups unit
5530: ,pa_projects_all p
5531: ,pa_project_types pt
5532: ,pa_tasks t3
5533: ,pa_tasks t5
5534: where
5535: adl.award_id = X_Award_Id
5536: and ei.expenditure_item_id = adl.expenditure_item_id
5537: and adl.fc_status = 'A'

Line 5567: from pa_tasks t

5563: and gspf.project_id = adl.project_id
5564: and (gspf.task_id is NULL or
5565: gspf.task_id = adl.task_id or
5566: gspf.task_id = (select t.top_task_id
5567: from pa_tasks t
5568: where t.task_id = adl.task_id
5569: )
5570: )
5571: )

Line 6793: ||' pa_tasks t3, pa_tasks t5, gms_award_distributions adl ';

6789: ei.transaction_source '; --bug 2909746
6790:
6791: X_Fixed_From := 'pa_expenditure_items_all ei ,pa_expenditures_all e, pa_expenditure_types et,'
6792: ||' pa_projects_all p, pa_project_types pt,'
6793: ||' pa_tasks t3, pa_tasks t5, gms_award_distributions adl ';
6794:
6795: /* --- 11.5 changes --- */
6796: --1. gms_award_distributions added in the from clause
6797: --2. 4 new columns being selected from gms_award_distributions, raw_cost picked differently

Line 6846: ||'OR (gspf.task_id = (select t1.top_task_id from pa_tasks t1 where t1.task_id = adl.task_id)) '

6842: ||'where gspf.installment_id = :C_Installment_Id '
6843: ||'and ( '
6844: ||' (gspf.task_id = adl.task_id) '
6845: ||'OR (gspf.task_id is NULL) '
6846: ||'OR (gspf.task_id = (select t1.top_task_id from pa_tasks t1 where t1.task_id = adl.task_id)) '
6847: ||' ) '
6848: ||'and gspf.project_id = adl.project_id '
6849: ||') ';
6850: