APPS.PA_FP_WEBADI_PKG dependencies on PA_RESOURCE_LIST_MEMBERS

Line 1727: l_unct_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

1723: i INTEGER := 0;
1724: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE;
1725: l_prc_error_code VARCHAR2(30);
1726:
1727: l_unct_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1728: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
1729:
1730: l_plan_trans_attr_copied_flag VARCHAR2(1);
1731: l_cost_conv_attr_copied_flag VARCHAR2(1);

Line 2201: FROM pa_resource_list_members rlm

2197: inf.prd51 = DECODE(inf.delete_flag,'Y',l_fnd_miss_num,inf.prd51 ),
2198: inf.prd52 = DECODE(inf.delete_flag,'Y',l_fnd_miss_num,inf.prd52 ),
2199: inf.sd_prd = DECODE(inf.delete_flag,'Y',l_fnd_miss_num , inf.sd_prd),
2200: inf.resource_list_member_id = (SELECT rlm.resource_list_member_id
2201: FROM pa_resource_list_members rlm
2202: WHERE inf.resource_alias = rlm.alias
2203: AND rlm.resource_list_id = p_version_info_rec.x_resource_list_id
2204: AND rlm.object_type = 'PROJECT'
2205: AND rlm.object_id = p_version_info_rec.x_project_id),

Line 2331: FROM pa_resource_list_members rlm

2327: inf.prd51 = DECODE(inf.delete_flag,'Y',l_fnd_miss_num,inf.prd51 ),
2328: inf.prd52 = DECODE(inf.delete_flag,'Y',l_fnd_miss_num,inf.prd52 ),
2329: inf.sd_prd = DECODE(inf.delete_flag,'Y',l_fnd_miss_num , inf.sd_prd),
2330: inf.resource_list_member_id = (SELECT rlm.resource_list_member_id
2331: FROM pa_resource_list_members rlm
2332: WHERE inf.resource_alias = rlm.alias
2333: AND rlm.resource_list_id = p_version_info_rec.x_resource_list_id
2334: AND rlm.object_type = 'RESOURCE_LIST'
2335: AND rlm.object_id = p_version_info_rec.x_resource_list_id),

Line 2352: FROM pa_resource_list_members

2348:
2349: -- 4497319.Perf Fix:Added two AND conditions in the WHERE clause in order to improve the performance.
2350: SELECT resource_list_member_id
2351: INTO l_unct_rlm_id
2352: FROM pa_resource_list_members
2353: WHERE resource_list_id = p_version_info_rec.x_resource_list_id
2354: AND resource_class_flag = 'Y'
2355: AND resource_class_code = 'FINANCIAL_ELEMENTS'
2356: AND object_type = 'RESOURCE_LIST'

Line 3010: -- or from pa_resource_list_members for new RAs.

3006:
3007: -- checking if the RA is an existing one or a new one
3008: IF NOT l_cached_ra_id_tbl.EXISTS(l_cached_ra_index) THEN
3009: -- deriving planning dates and spread curve information from pa_resource_assignments for existing RAs
3010: -- or from pa_resource_list_members for new RAs.
3011: BEGIN
3012: SELECT resource_assignment_id,
3013: planning_start_date,
3014: planning_end_date,

Line 3045: FROM pa_resource_list_members

3041: --log1('----- STAGE 10-------');
3042: BEGIN
3043: SELECT spread_curve_id
3044: INTO l_spread_curve_id
3045: FROM pa_resource_list_members
3046: WHERE resource_list_member_id = l_inf_tbl_data_curr_rec.resource_list_member_id;
3047: EXCEPTION
3048: WHEN OTHERS THEN
3049: IF l_debug_mode = 'Y' THEN

Line 6164: p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE,

6160: PROCEDURE get_total_fcst_amounts
6161: (p_project_id IN pa_projects_all.project_id%TYPE,
6162: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6163: p_task_id IN pa_tasks.task_id%TYPE,
6164: p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE,
6165: p_cbs_element_id IN pa_resource_assignments.cbs_element_id%TYPE, -- cbs enhancement changes bug#16445106
6166: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
6167: p_line_start_date IN DATE,
6168: p_line_end_date IN DATE,

Line 12114: pa_resource_list_members prlm,

12110: pa_resource_asgn_curr prac,
12111: pa_fp_txn_currencies pftc,
12112: pa_proj_elements pe,
12113: pa_proj_element_versions pev,
12114: pa_resource_list_members prlm,
12115: pa_lookups uom,
12116: pa_spread_curves_tl psc,
12117: cst_cost_types cct,
12118: pa_lookups etc,