DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_UTILS dependencies on PA_PROBABILITY_MEMBERS

Line 571: ,x_prob_percent OUT NOCOPY pa_probability_members.probability_percentage%TYPE --File.Sql.39 bug 4440895

567:
568: PROCEDURE get_probability_percent
569: ( p_project_id IN pa_projects_all.project_id%TYPE
570: := NULL
571: ,x_prob_percent OUT NOCOPY pa_probability_members.probability_percentage%TYPE --File.Sql.39 bug 4440895
572: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
573: ,x_err_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
574: IS
575: l_debug_mode VARCHAR2(30);

Line 599: FROM pa_probability_members

595: x_prob_percent := 100;
596: ELSE
597: SELECT nvl(probability_percentage,100)
598: INTO x_prob_percent
599: FROM pa_probability_members
600: WHERE probability_member_id = l_probability_member_id;
601: END IF;
602: pa_debug.g_err_stage := 'Txn Project_id = ['||p_project_id ||']';
603: IF P_PA_DEBUG_MODE = 'Y' THEN