APPS.PA_FAXFACE dependencies on PA_PROJECT_TYPES

Line 1959: pa_project_types pt

1955:
1956: SELECT pt.capital_cost_type_code
1957: INTO l_amount_type
1958: FROM pa_projects ppr,
1959: pa_project_types pt
1960: WHERE ppr.project_type=pt.project_type
1961: AND project_id=x_project_id;
1962:
1963: FOR cdlrec IN selcdls(x_project_id,

Line 3337: pa_project_types ppt

3333: FROM
3334: pa_project_asset_lines pal,
3335: pa_project_assets ppa,
3336: pa_projects pp,
3337: pa_project_types ppt
3338: WHERE
3339: pal.project_asset_id = ppa.project_asset_id
3340: AND ppa.project_id = pp.project_id
3341: AND ppa.project_id = x_project_id

Line 4052: pa_project_types pt

4048: 'Y')) total_burden_flag,
4049: pt.Burden_amt_display_method
4050: FROM
4051: pa_projects ppr,
4052: pa_project_types pt
4053: WHERE
4054: ppr.segment1 between x_project_num_from and x_project_num_to and
4055: ppr.template_flag <> 'Y' and
4056: PA_PROJECT_UTILS.Check_prj_stus_action_allowed(ppr.project_status_code,

Line 4605: pa_project_types pt,

4601: ppr.project_id,
4602: ppr.segment1
4603: FROM
4604: pa_projects ppr,
4605: pa_project_types pt,
4606: pa_project_asset_lines pal
4607: WHERE
4608: ppr.segment1 between x_project_num_from and x_project_num_to and
4609: ppr.template_flag <> 'Y' and

Line 4835: pa_project_types pt

4831: SELECT
4832: ppr.project_id
4833: FROM
4834: pa_projects ppr,
4835: pa_project_types pt
4836: WHERE
4837: ppr.segment1 between x_project_num_from and x_project_num_to and
4838: ppr.template_flag <> 'Y' and
4839: PA_PROJECT_UTILS.Check_prj_stus_action_allowed(ppr.project_status_code,

Line 4998: pa_project_types pt

4994: FROM pa_cost_distribution_lines_all pcdl,
4995: pa_expenditure_items_all pei,
4996: pa_tasks pat,
4997: pa_projects pp,
4998: pa_project_types pt
4999: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5000: AND pp.project_id = p_project_id
5001: AND pp.project_type = pt.project_type
5002: AND pei.revenue_distributed_flag||'' = 'N'

Line 5086: pa_project_types pt

5082: FROM pa_cost_distribution_lines_all pcdl,
5083: pa_expenditure_items_all pei,
5084: pa_tasks pat,
5085: pa_projects pp,
5086: pa_project_types pt
5087: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5088: AND pp.project_id = p_project_id
5089: AND pp.project_type = pt.project_type
5090: AND pei.revenue_distributed_flag||'' = 'N'

Line 5137: pa_project_types pt

5133: FROM pa_cost_distribution_lines_all pcdl,
5134: pa_expenditure_items_all pei,
5135: --pa_tasks pat, /* bug fix :2830211 task_id is not reqd */
5136: pa_projects_all pp,
5137: pa_project_types pt
5138: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5139: AND pp.project_id = p_project_id
5140: AND pei.project_id = pp.project_id /* added for bug fix :2830211 */
5141: AND pp.project_type = pt.project_type

Line 5335: pa_project_types ppt

5331: FROM
5332: pa_project_asset_lines pal,
5333: pa_project_assets ppa,
5334: pa_projects pp,
5335: pa_project_types ppt
5336: WHERE
5337: pal.project_asset_id = ppa.project_asset_id
5338: AND ppa.project_id = pp.project_id
5339: AND ppa.project_id = x_project_id

Line 5604: pa_project_types pt

5600: /* Commented for bug 5758490
5601: CURSOR no_event_proj_cur IS
5602: SELECT p.project_id
5603: FROM pa_projects p,
5604: pa_project_types pt
5605: WHERE p.segment1
5606: BETWEEN x_project_num_from AND x_project_num_to
5607: AND p.template_flag <> 'Y'
5608: AND PA_PROJECT_UTILS.Check_prj_stus_action_allowed(p.project_status_code,'CAPITALIZE') = 'Y'

Line 5898: FROM pa_project_types_all p_type,

5894: Elsif (l_historical_flag = 'Y') Then
5895:
5896: SELECT p_type.capital_cost_type_code
5897: INTO l_capital_cost_type
5898: FROM pa_project_types_all p_type,
5899: pa_projects_all proj,
5900: pa_cost_distribution_lines_all pa_cdl
5901: WHERE p_type.project_type = proj.project_type
5902: AND proj.project_id = pa_cdl.project_id