DBA Data[Home] [Help]

APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_SRP_PERIOD_QUOTAS_S

Line 510: cn_srp_period_quotas_s.nextval

506: ,last_updated_by
507: ,last_update_login
508: ,org_id )
509: SELECT
510: cn_srp_period_quotas_s.nextval
511: ,qa.srp_plan_assign_id
512: ,qa.srp_quota_assign_id
513: ,pa.salesrep_id
514: ,p.period_id

Line 622: cn_srp_period_quotas_s.nextval

618: ,last_updated_by
619: ,last_update_login
620: ,org_id )
621: SELECT
622: cn_srp_period_quotas_s.nextval
623: ,qa.srp_plan_assign_id
624: ,qa.srp_quota_assign_id
625: ,pa.salesrep_id
626: ,p.period_id

Line 713: SELECT cn_srp_period_quotas_s.nextval

709: ,last_update_date
710: ,last_updated_by
711: ,last_update_login
712: ,org_id )
713: SELECT cn_srp_period_quotas_s.nextval
714: ,qa.srp_plan_assign_id
715: ,qa.srp_quota_assign_id
716: ,pa.salesrep_id
717: ,p.period_id

Line 980: cn_srp_period_quotas spq

976:
977: -- get precision
978: select c.extended_precision INTO g_ext_precision
979: from cn_repositories r, gl_sets_of_books b, fnd_currencies c,
980: cn_srp_period_quotas spq
981: where r.org_id = spq.org_id
982: and r.set_of_books_id = b.set_of_books_id
983: and b.currency_code = c.currency_code
984: AND spq.srp_period_quota_id = x_srp_period_quota_id;