DBA Data[Home] [Help]

APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_RESOURCE_LIST_MEMBERS

Line 1146: PA_RESOURCE_LIST_MEMBERS RLM

1142: PA_FORECAST_ITEM_DETAILS FID,
1143: PA_PERIODS_ALL P,
1144: PA_RES_LIST_MAP_TMP4 TMP4,
1145: PA_RESOURCE_ASSIGNMENTS RA,
1146: PA_RESOURCE_LIST_MEMBERS RLM
1147: WHERE FI.PROJECT_ORG_ID = NVL(P.ORG_ID,-99)
1148: AND P.ORG_ID = c_org_id /* Bug 5657334 */
1149: AND P.PERIOD_NAME = FI.RCVR_PA_PERIOD_NAME
1150: AND FI.FORECAST_ITEM_ID = FID.FORECAST_ITEM_ID

Line 1221: PA_RESOURCE_LIST_MEMBERS RLM

1217: PA_FORECAST_ITEM_DETAILS FID,
1218: GL_PERIODS GLP,
1219: PA_RES_LIST_MAP_TMP4 TMP4,
1220: PA_RESOURCE_ASSIGNMENTS RA,
1221: PA_RESOURCE_LIST_MEMBERS RLM
1222: WHERE FI.FORECAST_ITEM_ID = FID.FORECAST_ITEM_ID
1223: AND FID.FORECAST_SUMMARIZED_CODE = 'N'
1224: AND FID.NET_ZERO_FLAG = 'N'
1225: AND FI.ERROR_FLAG = 'N'

Line 1295: PA_RESOURCE_LIST_MEMBERS RLM

1291: FROM PA_FORECAST_ITEMS FI,
1292: PA_FORECAST_ITEM_DETAILS FID,
1293: PA_RES_LIST_MAP_TMP4 TMP4,
1294: PA_RESOURCE_ASSIGNMENTS RA,
1295: PA_RESOURCE_LIST_MEMBERS RLM
1296: WHERE FI.FORECAST_ITEM_ID = FID.FORECAST_ITEM_ID
1297: AND FID.FORECAST_SUMMARIZED_CODE = 'N'
1298: AND FID.NET_ZERO_FLAG = 'N'
1299: AND FI.ERROR_FLAG = 'N'

Line 1663: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;

1659: l_cost_reject_reason VARCHAR2(1000);
1660: l_burdened_reject_reason VARCHAR2(1000);
1661: l_other_reject_reason VARCHAR2(1000);
1662:
1663: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
1664: l_resource_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
1665: l_resource_assignment_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1666: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;
1667: l_parent_member_id PA_RESOURCE_LIST_MEMBERS.PARENT_MEMBER_ID%TYPE;

Line 1664: l_resource_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;

1660: l_burdened_reject_reason VARCHAR2(1000);
1661: l_other_reject_reason VARCHAR2(1000);
1662:
1663: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
1664: l_resource_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
1665: l_resource_assignment_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1666: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;
1667: l_parent_member_id PA_RESOURCE_LIST_MEMBERS.PARENT_MEMBER_ID%TYPE;
1668: l_prj_res_assignment_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;

Line 1666: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;

1662:
1663: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
1664: l_resource_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
1665: l_resource_assignment_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1666: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;
1667: l_parent_member_id PA_RESOURCE_LIST_MEMBERS.PARENT_MEMBER_ID%TYPE;
1668: l_prj_res_assignment_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1669:
1670: l_fcst_opt_jobcostrate_sch_id PA_FORECASTING_OPTIONS_ALL.JOB_COST_RATE_SCHEDULE_ID%TYPE;

Line 1667: l_parent_member_id PA_RESOURCE_LIST_MEMBERS.PARENT_MEMBER_ID%TYPE;

1663: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
1664: l_resource_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
1665: l_resource_assignment_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1666: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;
1667: l_parent_member_id PA_RESOURCE_LIST_MEMBERS.PARENT_MEMBER_ID%TYPE;
1668: l_prj_res_assignment_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1669:
1670: l_fcst_opt_jobcostrate_sch_id PA_FORECASTING_OPTIONS_ALL.JOB_COST_RATE_SCHEDULE_ID%TYPE;
1671:

Line 6434: pa_resource_list_members rlm

6430: l_res_format_id_tab
6431: FROM pa_fp_calc_amt_tmp2 tmp, pa_resource_assignments ra,
6432: pa_projects_all proj, pa_tasks t,
6433: pa_proj_fp_options fp,
6434: pa_resource_list_members rlm
6435: WHERE tmp.resource_assignment_id = ra.resource_assignment_id
6436: AND ra.project_id = proj.project_id
6437: AND ra.task_id = t.task_id(+)
6438: AND fp.fin_plan_version_id = ra.budget_version_id

Line 6978: pa_resource_list_members rlm

6974: l_res_format_id_tab
6975: FROM pa_fp_calc_amt_tmp2 tmp, pa_resource_assignments ra,
6976: pa_projects_all proj, pa_tasks t,
6977: pa_proj_fp_options fp,
6978: pa_resource_list_members rlm
6979: WHERE tmp.resource_assignment_id = ra.resource_assignment_id
6980: AND ra.project_id = proj.project_id
6981: AND ra.task_id = t.task_id(+)
6982: AND fp.fin_plan_version_id = ra.budget_version_id