APPS.PA_FIN_PLAN_TYPES_UTILS dependencies on PA_BUDGET_VERSIONS

Line 575: FROM pa_budget_versions bv,

571: INTO l_partial_cos_exist
572: FROM DUAL
573: WHERE
574: EXISTS (SELECT 'X'
575: FROM pa_budget_versions bv,
576: pa_control_items ci
577: WHERE ci.ci_id=bv.ci_id
578: AND bv.fin_plan_type_id= p_fin_plan_type_id
579: AND bv.rev_partially_impl_flag='Y'

Line 609: FROM pa_budget_versions

605: BEGIN
606:
607: SELECT 'Y'
608: INTO l_return_flag
609: FROM pa_budget_versions
610: WHERE fin_plan_type_id = p_fin_plan_type_id
611: AND rev_partially_impl_flag = 'Y'
612: AND ci_id is not null
613: AND ROWNUM = 1;

Line 816: (p_ci_id IN pa_budget_versions.ci_id%TYPE,

812: * This function is different from the function 'partially_impl_cos_exist'
813: * as it checks for partial revenue implementation for CI_ID
814: */
815: FUNCTION Is_Rev_Impl_Partially
816: (p_ci_id IN pa_budget_versions.ci_id%TYPE,
817: p_project_id IN pa_budget_versions.project_id%TYPE)
818: RETURN VARCHAR2
819:
820: IS

Line 817: p_project_id IN pa_budget_versions.project_id%TYPE)

813: * as it checks for partial revenue implementation for CI_ID
814: */
815: FUNCTION Is_Rev_Impl_Partially
816: (p_ci_id IN pa_budget_versions.ci_id%TYPE,
817: p_project_id IN pa_budget_versions.project_id%TYPE)
818: RETURN VARCHAR2
819:
820: IS
821: l_rev_partial_impl_flag VARCHAR2(1);

Line 852: FROM pa_budget_versions

848:
849: BEGIN
850: SELECT Nvl(rev_partially_impl_flag, 'N')
851: INTO l_rev_partial_impl_flag
852: FROM pa_budget_versions
853: WHERE ci_id = p_ci_id
854: AND project_id = p_project_id
855: AND version_type IN ('REVENUE','ALL');
856: