DBA Data[Home] [Help]

APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_RESOURCE_LIST_MEMBERS

Line 1158: PA_RESOURCE_LIST_MEMBERS RLM

1154: PA_FORECAST_ITEM_DETAILS FID,
1155: PA_PERIODS_ALL P,
1156: PA_RES_LIST_MAP_TMP4 TMP4,
1157: PA_RESOURCE_ASSIGNMENTS RA,
1158: PA_RESOURCE_LIST_MEMBERS RLM
1159: WHERE FI.PROJECT_ORG_ID = NVL(P.ORG_ID,-99)
1160: AND P.ORG_ID = c_org_id /* Bug 5657334 */
1161: AND P.PERIOD_NAME = FI.RCVR_PA_PERIOD_NAME
1162: AND FI.FORECAST_ITEM_ID = FID.FORECAST_ITEM_ID

Line 1233: PA_RESOURCE_LIST_MEMBERS RLM

1229: PA_FORECAST_ITEM_DETAILS FID,
1230: GL_PERIODS GLP,
1231: PA_RES_LIST_MAP_TMP4 TMP4,
1232: PA_RESOURCE_ASSIGNMENTS RA,
1233: PA_RESOURCE_LIST_MEMBERS RLM
1234: WHERE FI.FORECAST_ITEM_ID = FID.FORECAST_ITEM_ID
1235: AND FID.FORECAST_SUMMARIZED_CODE = 'N'
1236: AND FID.NET_ZERO_FLAG = 'N'
1237: AND FI.ERROR_FLAG = 'N'

Line 1307: PA_RESOURCE_LIST_MEMBERS RLM

1303: FROM PA_FORECAST_ITEMS FI,
1304: PA_FORECAST_ITEM_DETAILS FID,
1305: PA_RES_LIST_MAP_TMP4 TMP4,
1306: PA_RESOURCE_ASSIGNMENTS RA,
1307: PA_RESOURCE_LIST_MEMBERS RLM
1308: WHERE FI.FORECAST_ITEM_ID = FID.FORECAST_ITEM_ID
1309: AND FID.FORECAST_SUMMARIZED_CODE = 'N'
1310: AND FID.NET_ZERO_FLAG = 'N'
1311: AND FI.ERROR_FLAG = 'N'

Line 1675: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;

1671: l_cost_reject_reason VARCHAR2(1000);
1672: l_burdened_reject_reason VARCHAR2(1000);
1673: l_other_reject_reason VARCHAR2(1000);
1674:
1675: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
1676: l_resource_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
1677: l_resource_assignment_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1678: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;
1679: l_parent_member_id PA_RESOURCE_LIST_MEMBERS.PARENT_MEMBER_ID%TYPE;

Line 1676: l_resource_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;

1672: l_burdened_reject_reason VARCHAR2(1000);
1673: l_other_reject_reason VARCHAR2(1000);
1674:
1675: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
1676: l_resource_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
1677: l_resource_assignment_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1678: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;
1679: l_parent_member_id PA_RESOURCE_LIST_MEMBERS.PARENT_MEMBER_ID%TYPE;
1680: l_prj_res_assignment_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;

Line 1678: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;

1674:
1675: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
1676: l_resource_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
1677: l_resource_assignment_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1678: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;
1679: l_parent_member_id PA_RESOURCE_LIST_MEMBERS.PARENT_MEMBER_ID%TYPE;
1680: l_prj_res_assignment_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1681:
1682: l_fcst_opt_jobcostrate_sch_id PA_FORECASTING_OPTIONS_ALL.JOB_COST_RATE_SCHEDULE_ID%TYPE;

Line 1679: l_parent_member_id PA_RESOURCE_LIST_MEMBERS.PARENT_MEMBER_ID%TYPE;

1675: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
1676: l_resource_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
1677: l_resource_assignment_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1678: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;
1679: l_parent_member_id PA_RESOURCE_LIST_MEMBERS.PARENT_MEMBER_ID%TYPE;
1680: l_prj_res_assignment_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1681:
1682: l_fcst_opt_jobcostrate_sch_id PA_FORECASTING_OPTIONS_ALL.JOB_COST_RATE_SCHEDULE_ID%TYPE;
1683:

Line 7091: pa_resource_list_members rlm

7087: l_res_format_id_tab
7088: FROM pa_fp_calc_amt_tmp2 tmp, pa_resource_assignments ra,
7089: pa_projects_all proj, pa_tasks t,
7090: pa_proj_fp_options fp,
7091: pa_resource_list_members rlm
7092: WHERE tmp.resource_assignment_id = ra.resource_assignment_id
7093: AND ra.project_id = proj.project_id
7094: AND ra.task_id = t.task_id(+)
7095: AND fp.fin_plan_version_id = ra.budget_version_id

Line 7635: pa_resource_list_members rlm

7631: l_res_format_id_tab
7632: FROM pa_fp_calc_amt_tmp2 tmp, pa_resource_assignments ra,
7633: pa_projects_all proj, pa_tasks t,
7634: pa_proj_fp_options fp,
7635: pa_resource_list_members rlm
7636: WHERE tmp.resource_assignment_id = ra.resource_assignment_id
7637: AND ra.project_id = proj.project_id
7638: AND ra.task_id = t.task_id(+)
7639: AND fp.fin_plan_version_id = ra.budget_version_id