APPS.PA_FORECAST_REVENUE dependencies on PA_PROJECTS_ALL

Line 84: l_rev_currency_code pa_projects_all.project_currency_code%TYPE; -- variable to store exp_func_curr_code

80: -- and used it to validate whether the
81: -- calling procedure has run successfully
82: -- or encounter any error
83:
84: l_rev_currency_code pa_projects_all.project_currency_code%TYPE; -- variable to store exp_func_curr_code
85: l_x_msg_data VARCHAR2(30);
86: l_x_msg_count NUMBER;
87: l_x_markup_percentage NUMBER;
88: l_asgn_type VARCHAR2(1);

Line 92: l_org_id pa_projects_all.org_id%TYPE;

88: l_asgn_type VARCHAR2(1);
89: l_exp_res_org_id pa_project_assignments.expenditure_org_id%TYPE;
90: l_exp_orgz_res_id pa_project_assignments.expenditure_organization_id%TYPE;
91: l_exp_type pa_project_assignments.expenditure_type%TYPE;
92: l_org_id pa_projects_all.org_id%TYPE;
93:
94: BEGIN
95:
96: -- Initializing return status with success sothat if some unexpected error comes

Line 112: FROM pa_projects_all

108: /* Selecting all the necessary inputs for this api */
109:
110: SELECT org_id
111: INTO l_org_id
112: FROM pa_projects_all
113: WHERE project_id = p_project_id;
114:
115: SELECT default_assign_exp_type
116: INTO l_exp_type