DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_UTILS dependencies on PA_PROJ_PERIOD_PROFILES

Line 628: ,p_period_profile_type IN pa_proj_period_profiles.period_profile_type%TYPE

624:
625: PROCEDURE get_period_profile
626: ( p_project_id IN pa_projects_all.project_id%TYPE
627: := NULL
628: ,p_period_profile_type IN pa_proj_period_profiles.period_profile_type%TYPE
629: := NULL
630: ,p_plan_period_type IN pa_forecasting_options.org_fcst_period_type%TYPE
631: := NULL
632: ,p_period_set_name IN gl_periods.period_set_name%TYPE

Line 660: FROM pa_proj_period_profiles ppp

656: x_return_status := FND_API.G_RET_STS_SUCCESS;
657: BEGIN
658: SELECT ppp.period_profile_id
659: INTO x_period_profile_id
660: FROM pa_proj_period_profiles ppp
661: WHERE ppp.project_id = p_project_id
662: AND ppp.period_profile_type = p_period_profile_type
663: AND ppp.plan_period_type = p_plan_period_type
664: AND ppp.period_set_name = p_period_set_name