DBA Data[Home] [Help]

APPS.CN_SRP_PAYEE_ASSIGNS_PVT dependencies on CN_PAYRUNS_ALL

Line 703: cn_payruns_all p,

699: cursor get_worksheets(l_srp_payee_assign_id number) IS
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

Line 986: cn_payruns_all p,

982: CURSOR get_worksheets IS
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