APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_SRP_PERIOD_QUOTAS_S

Line 494: SELECT cn_srp_period_quotas_s.nextval ,

490: last_updated_by ,
491: last_update_login ,
492: org_id
493: )
494: SELECT cn_srp_period_quotas_s.nextval ,
495: qa.srp_plan_assign_id ,
496: qa.srp_quota_assign_id ,
497: pa.salesrep_id ,
498: p.period_id ,

Line 609: SELECT cn_srp_period_quotas_s.nextval ,

605: last_updated_by ,
606: last_update_login ,
607: org_id
608: )
609: SELECT cn_srp_period_quotas_s.nextval ,
610: qa.srp_plan_assign_id ,
611: qa.srp_quota_assign_id ,
612: pa.salesrep_id ,
613: p.period_id ,

Line 708: SELECT cn_srp_period_quotas_s.nextval ,

704: last_updated_by ,
705: last_update_login ,
706: org_id
707: )
708: SELECT cn_srp_period_quotas_s.nextval ,
709: qa.srp_plan_assign_id ,
710: qa.srp_quota_assign_id ,
711: pa.salesrep_id ,
712: p.period_id ,

Line 978: cn_srp_period_quotas spq

974: INTO g_ext_precision
975: FROM cn_repositories r,
976: gl_sets_of_books b ,
977: fnd_currencies c ,
978: cn_srp_period_quotas spq
979: WHERE r.org_id = spq.org_id
980: AND r.set_of_books_id = b.set_of_books_id
981: AND b.currency_code = c.currency_code
982: AND spq.srp_period_quota_id = x_srp_period_quota_id;