APPS.PA_COST dependencies on PA_PROJECTS_ALL

Line 66: l_ot_project_id pa_projects_all.project_id%type;

62: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
63: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
64: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
65: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;
66: l_ot_project_id pa_projects_all.project_id%type;
67: l_ot_task_id pa_tasks.task_id%type;
68: l_err_code varchar2(200);
69: l_err_stage number;
70: l_return_value varchar2(100);

Line 612: FROM pa_project_types_all typ, pa_projects_all proj

608: ------------------------------------------------------
609: -- Bug 7423839 removed refernce to project type
610: SELECT burden_cost_flag
611: INTO l_burden_cost_flag
612: FROM pa_project_types_all typ, pa_projects_all proj
613: WHERE proj.project_id = p_project_id
614: AND proj.project_type = typ.project_type
615: AND proj.org_id = typ.org_id; -- bug 5365286
616: /* Commented for Bug 7423839

Line 619: FROM pa_project_types_all typ, pa_projects_all proj

615: AND proj.org_id = typ.org_id; -- bug 5365286
616: /* Commented for Bug 7423839
617: SELECT burden_cost_flag
618: INTO l_burden_cost_flag
619: FROM pa_project_types_all typ, pa_projects_all proj
620: WHERE typ.project_type = P_project_type
621: AND proj.project_type = typ.project_type
622: AND proj.project_id = p_project_id
623: AND proj.org_id = typ.org_id; -- bug 5365286

Line 942: l_proj_org_id pa_projects_all.org_id%TYPE;

938: x_msg_data OUT NOCOPY VARCHAR2
939: )
940: IS
941:
942: l_proj_org_id pa_projects_all.org_id%TYPE;
943: l_exp_org_id pa_project_assignments.expenditure_org_id%TYPE; /* Changed for Org Forecasting */
944: l_txn_raw_cost NUMBER; /* Added for Org Forecasting */
945: l_txn_raw_cost_rate NUMBER; /* Added for Org Forecasting */
946: l_txn_burden_cost NUMBER; /* Added for Org Forecasting */

Line 1095: FROM pa_projects_all prj,

1091: 'P',get_pa_date(p_item_date,p_exp_org_id))),
1092: NVL(tsk.project_rate_type, imp.default_rate_type)
1093: INTO l_projfunc_rate_date,
1094: l_projfunc_rate_type
1095: FROM pa_projects_all prj,
1096: pa_tasks tsk,
1097: pa_implementations_all imp
1098: WHERE prj.project_id = p_project_id
1099: AND prj.project_id = tsk.project_id

Line 1120: FROM pa_projects_all prj,

1116: 'P',get_pa_date(p_item_date,p_exp_org_id))),
1117: NVL(prj.projfunc_cost_rate_type, imp.default_rate_type)
1118: INTO l_projfunc_rate_date,
1119: l_projfunc_rate_type
1120: FROM pa_projects_all prj,
1121: pa_implementations_all imp
1122: WHERE prj.project_id = p_project_id
1123: AND nvl(prj.org_id,-99) = nvl(imp.org_id,-99)
1124: AND nvl(imp.org_id,-99) = nvl(p_proj_org_id,-99);

Line 1797: pa_projects_all prj

1793: 'INVOICE', prj.inv_ind_sch_fixed_date )
1794: INTO l_burden_sch_id,
1795: l_burden_sch_fixed_date
1796: FROM pa_ind_rate_schedules irs,
1797: pa_projects_all prj
1798: WHERE irs.project_id = prj.project_id
1799: AND irs.project_id = p_project_id
1800: AND irs.task_id is NULL
1801: AND ( (p_schedule_type = 'COST'

Line 1931: FROM pa_projects_all prj

1927: 'REVENUE', prj.rev_ind_sch_fixed_date,
1928: 'INVOICE', prj.inv_ind_sch_fixed_date)
1929: INTO l_burden_sch_id,
1930: l_burden_sch_fixed_date
1931: FROM pa_projects_all prj
1932: WHERE prj.project_id = p_project_id
1933: AND ( p_schedule_type = 'COST'
1934: OR p_schedule_type = 'REVENUE'
1935: OR p_schedule_type = 'INVOICE'

Line 2084: l_ot_project_id pa_projects_all.project_id%type;

2080: l_override_type pa_compensation_details.override_type%type;
2081: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
2082: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
2083: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
2084: l_ot_project_id pa_projects_all.project_id%type;
2085: l_ot_task_id pa_tasks.task_id%type;
2086: l_err_code varchar2(200);
2087: l_err_stage number;
2088: l_return_value varchar2(100);