APPS.CN_SRP_PAYEE_ASSIGNS_PVT dependencies on CN_SRP_PAYEE_ASSIGNS_ALL

Line 189: FROM cn_srp_payee_assigns_all

185: --check whether the payee's date overlap with the dates of
186: --other payee who is already assigned
187: SELECT count(1)
188: INTO l_count
189: FROM cn_srp_payee_assigns_all
190: WHERE srp_quota_assign_id = p_srp_quota_assign_id
191: AND delete_flag = 'N'
192: AND srp_payee_assign_id <> Nvl(p_srp_payee_assign_id, -1)
193: AND Greatest(start_date, p_start_date) <=

Line 606: FROM cn_srp_payee_assigns_all

602:
603: -- get new version number
604: SELECT object_version_number
605: INTO x_object_version_number
606: FROM cn_srp_payee_assigns_all
607: WHERE srp_payee_assign_id = x_srp_payee_assign_id;
608:
609: --+
610: -- Issue the Commit and recreate the Save Point.

Line 694: FROM cn_srp_payee_assigns_all

690:
691: CURSOR get_old_payee_rec(l_srp_payee_asgn_id number) IS
692: SELECT srp_quota_assign_id, payee_id, start_date, end_date,
693: quota_id, salesrep_id, org_id, object_version_number
694: FROM cn_srp_payee_assigns_all
695: WHERE srp_payee_assign_id = l_srp_payee_asgn_id;
696:
697: l_old_rec get_old_payee_rec%ROWTYPE;
698:

Line 702: cn_srp_payee_assigns_all spa,

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
706: w.salesrep_id = spa.salesrep_id)

Line 910: FROM cn_srp_payee_assigns_all

906:
907: -- get new version number
908: SELECT object_version_number
909: INTO p_object_version_number
910: FROM cn_srp_payee_assigns_all
911: WHERE srp_payee_assign_id = p_srp_payee_assign_id;
912:
913: --+
914: -- Issue the Commit and recreate the Save Point.

Line 985: cn_srp_payee_assigns_all spa,

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
989: w.salesrep_id = spa.salesrep_id)

Line 1010: FROM cn_srp_payee_assigns_all

1006: x_loading_status := 'CN_DELETED';
1007:
1008: SELECT start_date, end_date, org_id
1009: INTO l_start_date, l_end_date, l_org_id
1010: FROM cn_srp_payee_assigns_all
1011: WHERE srp_payee_assign_id = p_srp_payee_assign_id;
1012:
1013: -- check payee has no worksheet for bug 3390199
1014: FOR w IN get_worksheets loop

Line 1138: FROM cn_srp_payee_assigns_all

1134:
1135: -- get info for trigger
1136: SELECT salesrep_id, srp_quota_assign_id, start_date, end_date, org_id, payee_id
1137: INTO l_salesrep_id, l_srp_quota_assign_id, l_start_date, l_end_date, l_org_id, l_payee_id
1138: FROM cn_srp_payee_assigns_all
1139: WHERE srp_payee_assign_id = p_srp_payee_assign_id;
1140:
1141: cn_srp_payee_assigns_pkg.delete_record
1142: (p_srp_payee_assign_id => p_srp_payee_assign_id);