APPS.PA_CREATE_RESOURCE dependencies on PA_RESOURCE_FORMATS

Line 1466: pa_resource_formats

1462: CURSOR c_res_format_csr IS
1463: SELECT
1464: resource_format_id
1465: FROM
1466: pa_resource_formats
1467: WHERE person_id_flag = l_person_id_flag
1468: AND job_id_flag = l_job_id_flag
1469: AND organization_id_flag = l_proj_organization_id_flag
1470: AND vendor_id_flag = l_vendor_id_flag

Line 1516: -- Need to get the resource_format_id from pa_resource_formats

1512: l_revenue_category_code := p_revenue_category_code;
1513: l_project_role_id := p_project_role_id;
1514: ELSIF
1515: l_resource_class_code = 'PRE_DEFINED' THEN
1516: -- Need to get the resource_format_id from pa_resource_formats
1517: IF p_resource_type_code = 'EMPLOYEE' THEN
1518: l_person_id_flag := 'Y';
1519: l_person_id := p_person_id;
1520: ELSIF p_resource_type_code = 'JOB' THEN

Line 1547: p_err_stage := 'Select resource_format_id from pa_resource_formats ';

1543: l_project_role_id := p_project_role_id;
1544: END IF;
1545: END IF;
1546:
1547: p_err_stage := 'Select resource_format_id from pa_resource_formats ';
1548:
1549: OPEN c_res_format_csr;
1550: FETCH c_res_format_csr INTO
1551: l_resource_format_id;