DBA Data[Home] [Help]

APPS.CN_SRP_PAYEE_ASSIGNS_PVT dependencies on CN_PERIOD_STATUSES_ALL

Line 704: cn_period_statuses_all ps

700: SELECT ps.start_date, ps.end_date
701: FROM cn_payment_worksheets_all w,
702: cn_srp_payee_assigns_all spa,
703: cn_payruns_all p,
704: cn_period_statuses_all ps
705: WHERE (w.salesrep_id = spa.payee_id or
706: w.salesrep_id = spa.salesrep_id)
707: AND w.quota_id is NULL
708: AND w.org_id = spa.org_id

Line 987: cn_period_statuses_all ps

983: select ps.start_date, ps.end_date
984: from cn_payment_worksheets_all w,
985: cn_srp_payee_assigns_all spa,
986: cn_payruns_all p,
987: cn_period_statuses_all ps
988: where (w.salesrep_id = spa.payee_id or
989: w.salesrep_id = spa.salesrep_id)
990: AND w.org_id = spa.org_id
991: AND w.quota_id is null