APPS.PA_FAXFACE dependencies on PA_PROJECT_TYPES

Line 2206: pa_project_types pt

2202:
2203: SELECT pt.capital_cost_type_code
2204: INTO l_amount_type
2205: FROM pa_projects ppr,
2206: pa_project_types pt
2207: WHERE ppr.project_type=pt.project_type
2208: AND project_id=x_project_id;
2209:
2210: FOR cdlrec IN selcdls(x_project_id,

Line 3705: pa_project_types ppt

3701: FROM
3702: pa_project_asset_lines pal,
3703: pa_project_assets ppa,
3704: pa_projects pp,
3705: pa_project_types ppt
3706: WHERE
3707: pal.project_asset_id = ppa.project_asset_id
3708: AND ppa.project_id = pp.project_id
3709: AND ppa.project_id = x_project_id

Line 4436: pa_project_types pt

4432: 'Y')) total_burden_flag,
4433: pt.Burden_amt_display_method
4434: FROM
4435: pa_projects ppr,
4436: pa_project_types pt
4437: WHERE
4438: ppr.segment1 between x_project_num_from and x_project_num_to and
4439: ppr.template_flag <> 'Y' and
4440: PA_PROJECT_UTILS.Check_prj_stus_action_allowed(ppr.project_status_code,

Line 4991: pa_project_types pt,

4987: ppr.project_id,
4988: ppr.segment1
4989: FROM
4990: pa_projects ppr,
4991: pa_project_types pt,
4992: pa_project_asset_lines pal
4993: WHERE
4994: ppr.segment1 between x_project_num_from and x_project_num_to and
4995: ppr.template_flag <> 'Y' and

Line 5221: pa_project_types pt

5217: SELECT
5218: ppr.project_id
5219: FROM
5220: pa_projects ppr,
5221: pa_project_types pt
5222: WHERE
5223: ppr.segment1 between x_project_num_from and x_project_num_to and
5224: ppr.template_flag <> 'Y' and
5225: PA_PROJECT_UTILS.Check_prj_stus_action_allowed(ppr.project_status_code,

Line 5384: pa_project_types pt

5380: FROM pa_cost_distribution_lines_all pcdl,
5381: pa_expenditure_items_all pei,
5382: pa_tasks pat,
5383: pa_projects pp,
5384: pa_project_types pt
5385: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5386: AND pp.project_id = p_project_id
5387: AND pp.project_type = pt.project_type
5388: AND pei.revenue_distributed_flag||'' = 'N'

Line 5472: pa_project_types pt

5468: FROM pa_cost_distribution_lines_all pcdl,
5469: pa_expenditure_items_all pei,
5470: pa_tasks pat,
5471: pa_projects pp,
5472: pa_project_types pt
5473: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5474: AND pp.project_id = p_project_id
5475: AND pp.project_type = pt.project_type
5476: AND pei.revenue_distributed_flag||'' = 'N'

Line 5523: pa_project_types pt

5519: FROM pa_cost_distribution_lines_all pcdl,
5520: pa_expenditure_items_all pei,
5521: --pa_tasks pat, /* bug fix :2830211 task_id is not reqd */
5522: pa_projects_all pp,
5523: pa_project_types pt
5524: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5525: AND pp.project_id = p_project_id
5526: AND pei.project_id = pp.project_id /* added for bug fix :2830211 */
5527: AND pp.project_type = pt.project_type

Line 5721: pa_project_types ppt

5717: FROM
5718: pa_project_asset_lines pal,
5719: pa_project_assets ppa,
5720: pa_projects pp,
5721: pa_project_types ppt
5722: WHERE
5723: pal.project_asset_id = ppa.project_asset_id
5724: AND ppa.project_id = pp.project_id
5725: AND ppa.project_id = x_project_id

Line 5990: pa_project_types pt

5986: /* Commented for bug 5758490
5987: CURSOR no_event_proj_cur IS
5988: SELECT p.project_id
5989: FROM pa_projects p,
5990: pa_project_types pt
5991: WHERE p.segment1
5992: BETWEEN x_project_num_from AND x_project_num_to
5993: AND p.template_flag <> 'Y'
5994: AND PA_PROJECT_UTILS.Check_prj_stus_action_allowed(p.project_status_code,'CAPITALIZE') = 'Y'

Line 6344: FROM pa_project_types_all p_type,

6340: Elsif (l_historical_flag = 'Y') Then
6341:
6342: SELECT p_type.capital_cost_type_code
6343: INTO l_capital_cost_type
6344: FROM pa_project_types_all p_type,
6345: pa_projects_all proj,
6346: pa_cost_distribution_lines_all pa_cdl
6347: WHERE p_type.project_type = proj.project_type
6348: AND proj.project_id = pa_cdl.project_id