DBA Data[Home] [Help]

APPS.CN_API dependencies on CN_COMP_PLANS_ALL

Line 776: FROM cn_comp_plans_all

772:
773: BEGIN
774: SELECT name
775: INTO l_comp_plan_name
776: FROM cn_comp_plans_all
777: WHERE comp_plan_id = p_comp_plan_id;
778:
779: RETURN l_comp_plan_name;
780:

Line 798: FROM cn_comp_plans_all

794:
795: BEGIN
796: SELECT comp_plan_id
797: INTO l_comp_plan_id
798: FROM cn_comp_plans_all
799: WHERE name = p_comp_plan_name
800: AND org_id = p_org_id;
801:
802: RETURN l_comp_plan_id;

Line 1904: FROM cn_comp_plans_all

1900:
1901: BEGIN
1902: SELECT name, Nvl(p_rc_overlap,allow_rev_class_overlap),sum_trx_flag -- commented for bug 7655423
1903: INTO l_comp_plan_name,l_rc_overlap,l_sum_trx_flag
1904: FROM cn_comp_plans_all
1905: WHERE comp_plan_id = p_comp_plan_id;
1906: EXCEPTION
1907: WHEN NO_DATA_FOUND THEN
1908: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN