DBA Data[Home] [Help]

APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_PERIOD_QUOTAS_ALL

Line 514: cn_period_quotas_all pq ,

510: l_user_id ,
511: l_login_id ,
512: qa.org_id
513: FROM cn_srp_quota_assigns_all qa ,
514: cn_period_quotas_all pq ,
515: cn_srp_plan_assigns_all pa ,
516: cn_period_statuses p
517: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id
518: AND pa.srp_plan_assign_id = x_srp_plan_assign_id

Line 629: cn_period_quotas_all pq ,

625: l_user_id ,
626: l_login_id ,
627: qa.org_id
628: FROM cn_srp_quota_assigns_all qa ,
629: cn_period_quotas_all pq ,
630: cn_srp_plan_assigns_all pa ,
631: cn_period_statuses p
632: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id
633: AND pa.srp_plan_assign_id = qa.srp_plan_assign_id