APPS.PA_FP_GEN_AMOUNT_UTILS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 715: PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE,

711: PA_RESOURCE_ASSIGNMENTS.resource_list_member_id%TYPE,
712: P_TXN_CURRENCY_CODE IN
713: PA_BUDGET_LINES.txn_currency_code%TYPE,
714: X_RES_FORMAT_ID OUT NOCOPY
715: PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE,
716: X_RESOURCE_ASN_REC OUT NOCOPY RESOURCE_ASN_REC,
717: X_PA_TASKS_REC OUT NOCOPY PA_TASKS_REC,
718: X_PA_PROJECTS_ALL_REC OUT NOCOPY PA_PROJECTS_ALL_REC,
719: X_PROJ_FP_OPTIONS_REC OUT NOCOPY PROJ_FP_OPTIONS_REC,

Line 904: -- Local variables for pa_resource_list_members table

900: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
901: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
902: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
903:
904: -- Local variables for pa_resource_list_members table
905: l_res_format_id pa_resource_list_members.res_format_id%TYPE;
906:
907: -- Local variables for pa_proj_fp_options table
908: l_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE;

Line 905: l_res_format_id pa_resource_list_members.res_format_id%TYPE;

901: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
902: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
903:
904: -- Local variables for pa_resource_list_members table
905: l_res_format_id pa_resource_list_members.res_format_id%TYPE;
906:
907: -- Local variables for pa_proj_fp_options table
908: l_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE;
909: l_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE;

Line 1061: FROM pa_resource_list_members

1057:
1058:
1059: SELECT res_format_id
1060: INTO x_res_format_id
1061: FROM pa_resource_list_members
1062: WHERE resource_list_member_id = p_resource_list_member_id;
1063:
1064: OPEN get_proj_fp_options_csr;
1065: FETCH get_proj_fp_options_csr INTO x_proj_fp_options_rec;

Line 1331: P_RESOURCE_CLASS_CODE pa_resource_list_members.RESOURCE_CLASS_CODE%TYPE)

1327: END;
1328:
1329:
1330: FUNCTION GET_UC_RES_LIST_RLM_ID(P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE,
1331: P_RESOURCE_CLASS_CODE pa_resource_list_members.RESOURCE_CLASS_CODE%TYPE)
1332: RETURN NUMBER IS
1333: x_uc_res_list_rlm_id NUMBER;
1334: BEGIN
1335:

Line 1338: FROM pa_resource_list_members

1334: BEGIN
1335:
1336: SELECT resource_list_member_id
1337: INTO x_uc_res_list_rlm_id
1338: FROM pa_resource_list_members
1339: WHERE resource_class_code = P_RESOURCE_CLASS_CODE
1340: AND object_type = 'RESOURCE_LIST'
1341: AND resource_list_id = p_resource_list_id;
1342:

Line 1365: from pa_resource_list_members

1361:
1362: IF l_control_flag = 'Y' THEN
1363: select resource_list_member_id
1364: into x_rlm_id
1365: from pa_resource_list_members
1366: where object_type = 'RESOURCE_LIST'
1367: and object_id = p_resource_list_id
1368: and resource_list_id = p_resource_list_id
1369: and resource_class_code = P_RESOURCE_CLASS_CODE

Line 1374: from pa_resource_list_members

1370: and RESOURCE_CLASS_FLAG='Y';
1371: ELSE
1372: select resource_list_member_id
1373: into x_rlm_id
1374: from pa_resource_list_members
1375: where object_type = 'PROJECT'
1376: and object_id = p_project_id
1377: and resource_list_id = p_resource_list_id
1378: and resource_class_code = P_RESOURCE_CLASS_CODE