DBA Data[Home] [Help]

APPS.CN_API dependencies on CN_COMP_PLANS_ALL

Line 754: FROM cn_comp_plans_all

750:
751: BEGIN
752: SELECT name
753: INTO l_comp_plan_name
754: FROM cn_comp_plans_all
755: WHERE comp_plan_id = p_comp_plan_id;
756:
757: RETURN l_comp_plan_name;
758:

Line 776: FROM cn_comp_plans_all

772:
773: BEGIN
774: SELECT comp_plan_id
775: INTO l_comp_plan_id
776: FROM cn_comp_plans_all
777: WHERE name = p_comp_plan_name
778: AND org_id = p_org_id;
779:
780: RETURN l_comp_plan_id;

Line 1882: FROM cn_comp_plans_all

1878:
1879: BEGIN
1880: SELECT name, Nvl(p_rc_overlap,allow_rev_class_overlap)--,sum_trx_flag -- commented for bug 7655423
1881: INTO l_comp_plan_name,l_rc_overlap--,l_sum_trx_flag
1882: FROM cn_comp_plans_all
1883: WHERE comp_plan_id = p_comp_plan_id;
1884: EXCEPTION
1885: WHEN NO_DATA_FOUND THEN
1886: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN