APPS.CN_SRP_PAYEE_ASSIGNS_PVT dependencies on CN_PAYMENT_WORKSHEETS_ALL

Line 701: FROM cn_payment_worksheets_all w,

697: l_old_rec get_old_payee_rec%ROWTYPE;
698:
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

Line 984: from cn_payment_worksheets_all w,

980: l_org_id NUMBER;
981:
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