APPS.PA_CREATE_RESOURCE dependencies on PA_RESOURCE_FORMATS

Line 1813: pa_resource_formats

1809: CURSOR c_res_format_csr IS
1810: SELECT
1811: resource_format_id
1812: FROM
1813: pa_resource_formats
1814: WHERE person_id_flag = l_person_id_flag
1815: AND job_id_flag = l_job_id_flag
1816: AND organization_id_flag = l_proj_organization_id_flag
1817: AND vendor_id_flag = l_vendor_id_flag

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

1860: l_revenue_category_code := p_revenue_category_code;
1861: l_project_role_id := p_project_role_id;
1862: ELSIF
1863: l_resource_class_code = 'PRE_DEFINED' THEN
1864: -- Need to get the resource_format_id from pa_resource_formats
1865: IF p_resource_type_code = 'EMPLOYEE' THEN
1866: l_person_id_flag := 'Y';
1867: l_person_id := p_person_id;
1868: ELSIF p_resource_type_code = 'JOB' THEN

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

1891: l_project_role_id := p_project_role_id;
1892: END IF;
1893: END IF;
1894:
1895: p_err_stage := 'Select resource_format_id from pa_resource_formats ';
1896:
1897: OPEN c_res_format_csr;
1898: FETCH c_res_format_csr INTO
1899: l_resource_format_id;