APPS.PA_FP_WEBADI_PKG dependencies on PA_RESOURCE_LIST_MEMBERS

Line 1725: l_unct_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

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

Line 2185: FROM pa_resource_list_members rlm

2181: inf.prd51 = DECODE(inf.delete_flag,'Y',l_fnd_miss_num,inf.prd51 ),
2182: inf.prd52 = DECODE(inf.delete_flag,'Y',l_fnd_miss_num,inf.prd52 ),
2183: inf.sd_prd = DECODE(inf.delete_flag,'Y',l_fnd_miss_num , inf.sd_prd),
2184: inf.resource_list_member_id = (SELECT rlm.resource_list_member_id
2185: FROM pa_resource_list_members rlm
2186: WHERE inf.resource_alias = rlm.alias
2187: AND rlm.resource_list_id = p_version_info_rec.x_resource_list_id
2188: AND rlm.object_type = 'PROJECT'
2189: AND rlm.object_id = p_version_info_rec.x_project_id)

Line 2308: FROM pa_resource_list_members rlm

2304: inf.prd51 = DECODE(inf.delete_flag,'Y',l_fnd_miss_num,inf.prd51 ),
2305: inf.prd52 = DECODE(inf.delete_flag,'Y',l_fnd_miss_num,inf.prd52 ),
2306: inf.sd_prd = DECODE(inf.delete_flag,'Y',l_fnd_miss_num , inf.sd_prd),
2307: inf.resource_list_member_id = (SELECT rlm.resource_list_member_id
2308: FROM pa_resource_list_members rlm
2309: WHERE inf.resource_alias = rlm.alias
2310: AND rlm.resource_list_id = p_version_info_rec.x_resource_list_id
2311: AND rlm.object_type = 'RESOURCE_LIST'
2312: AND rlm.object_id = p_version_info_rec.x_resource_list_id)

Line 2325: FROM pa_resource_list_members

2321:
2322: -- 4497319.Perf Fix:Added two AND conditions in the WHERE clause in order to improve the performance.
2323: SELECT resource_list_member_id
2324: INTO l_unct_rlm_id
2325: FROM pa_resource_list_members
2326: WHERE resource_list_id = p_version_info_rec.x_resource_list_id
2327: AND resource_class_flag = 'Y'
2328: AND resource_class_code = 'FINANCIAL_ELEMENTS'
2329: AND object_type = 'RESOURCE_LIST'

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

2952:
2953: -- checking if the RA is an existing one or a new one
2954: IF NOT l_cached_ra_id_tbl.EXISTS(l_cached_ra_index) THEN
2955: -- deriving planning dates and spread curve information from pa_resource_assignments for existing RAs
2956: -- or from pa_resource_list_members for new RAs.
2957: BEGIN
2958: SELECT resource_assignment_id,
2959: planning_start_date,
2960: planning_end_date,

Line 2988: FROM pa_resource_list_members

2984: --log1('----- STAGE 10-------');
2985: BEGIN
2986: SELECT spread_curve_id
2987: INTO l_spread_curve_id
2988: FROM pa_resource_list_members
2989: WHERE resource_list_member_id = l_inf_tbl_data_curr_rec.resource_list_member_id;
2990: EXCEPTION
2991: WHEN OTHERS THEN
2992: IF l_debug_mode = 'Y' THEN

Line 6071: p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE,

6067: PROCEDURE get_total_fcst_amounts
6068: (p_project_id IN pa_projects_all.project_id%TYPE,
6069: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6070: p_task_id IN pa_tasks.task_id%TYPE,
6071: p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE,
6072: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
6073: p_line_start_date IN DATE,
6074: p_line_end_date IN DATE,
6075: p_prd_mask_st_date_tbl IN SYSTEM.pa_date_tbl_type,

Line 11881: pa_resource_list_members prlm,

11877: pa_resource_asgn_curr prac,
11878: pa_fp_txn_currencies pftc,
11879: pa_proj_elements pe,
11880: pa_proj_element_versions pev,
11881: pa_resource_list_members prlm,
11882: pa_lookups uom,
11883: pa_spread_curves_tl psc,
11884: cst_cost_types cct,
11885: pa_lookups etc,