APPS.PA_FP_GEN_AMOUNT_UTILS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 735: PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE,

731: PA_RESOURCE_ASSIGNMENTS.resource_list_member_id%TYPE,
732: P_TXN_CURRENCY_CODE IN
733: PA_BUDGET_LINES.txn_currency_code%TYPE,
734: X_RES_FORMAT_ID OUT NOCOPY
735: PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE,
736: X_RESOURCE_ASN_REC OUT NOCOPY RESOURCE_ASN_REC,
737: X_PA_TASKS_REC OUT NOCOPY PA_TASKS_REC,
738: X_PA_PROJECTS_ALL_REC OUT NOCOPY PA_PROJECTS_ALL_REC,
739: X_PROJ_FP_OPTIONS_REC OUT NOCOPY PROJ_FP_OPTIONS_REC,

Line 924: -- Local variables for pa_resource_list_members table

920: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
921: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
922: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
923:
924: -- Local variables for pa_resource_list_members table
925: l_res_format_id pa_resource_list_members.res_format_id%TYPE;
926:
927: -- Local variables for pa_proj_fp_options table
928: l_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE;

Line 925: l_res_format_id pa_resource_list_members.res_format_id%TYPE;

921: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
922: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
923:
924: -- Local variables for pa_resource_list_members table
925: l_res_format_id pa_resource_list_members.res_format_id%TYPE;
926:
927: -- Local variables for pa_proj_fp_options table
928: l_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE;
929: l_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE;

Line 1081: FROM pa_resource_list_members

1077:
1078:
1079: SELECT res_format_id
1080: INTO x_res_format_id
1081: FROM pa_resource_list_members
1082: WHERE resource_list_member_id = p_resource_list_member_id;
1083:
1084: OPEN get_proj_fp_options_csr;
1085: FETCH get_proj_fp_options_csr INTO x_proj_fp_options_rec;

Line 1351: P_RESOURCE_CLASS_CODE pa_resource_list_members.RESOURCE_CLASS_CODE%TYPE)

1347: END;
1348:
1349:
1350: FUNCTION GET_UC_RES_LIST_RLM_ID(P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE,
1351: P_RESOURCE_CLASS_CODE pa_resource_list_members.RESOURCE_CLASS_CODE%TYPE)
1352: RETURN NUMBER IS
1353: x_uc_res_list_rlm_id NUMBER;
1354: BEGIN
1355:

Line 1358: FROM pa_resource_list_members

1354: BEGIN
1355:
1356: SELECT resource_list_member_id
1357: INTO x_uc_res_list_rlm_id
1358: FROM pa_resource_list_members
1359: WHERE resource_class_code = P_RESOURCE_CLASS_CODE
1360: AND object_type = 'RESOURCE_LIST'
1361: AND resource_list_id = p_resource_list_id;
1362:

Line 1385: from pa_resource_list_members

1381:
1382: IF l_control_flag = 'Y' THEN
1383: select resource_list_member_id
1384: into x_rlm_id
1385: from pa_resource_list_members
1386: where object_type = 'RESOURCE_LIST'
1387: and object_id = p_resource_list_id
1388: and resource_list_id = p_resource_list_id
1389: and resource_class_code = P_RESOURCE_CLASS_CODE

Line 1394: from pa_resource_list_members

1390: and RESOURCE_CLASS_FLAG='Y';
1391: ELSE
1392: select resource_list_member_id
1393: into x_rlm_id
1394: from pa_resource_list_members
1395: where object_type = 'PROJECT'
1396: and object_id = p_project_id
1397: and resource_list_id = p_resource_list_id
1398: and resource_class_code = P_RESOURCE_CLASS_CODE