APPS.CN_SRP_PAYEE_ASSIGNS_PVT dependencies on CN_SRP_QUOTA_ASSIGNS

Line 168: FROM cn_srp_quota_assigns sqa, cn_srp_plan_assigns spa

164: -- make sure payee assignment falls within a valid plan assignment
165: -- fix for bug 4507995
166: SELECT COUNT(1)
167: INTO l_count
168: FROM cn_srp_quota_assigns sqa, cn_srp_plan_assigns spa
169: WHERE sqa.srp_quota_assign_id = p_srp_quota_assign_id
170: AND sqa.srp_plan_assign_id = spa.srp_plan_assign_id
171: AND p_start_date >= start_date
172: AND Nvl(p_end_date, l_end_of_time) <=

Line 321: FROM cn_quotas_all q, cn_srp_quota_assigns_all sqa

317:
318: -- Check wheather the payee can be assigned to this plan Element
319: SELECT payee_assign_flag, q.name, q.quota_id
320: INTO l_payee_assign_flag, l_pe_name, l_quota_id
321: FROM cn_quotas_all q, cn_srp_quota_assigns_all sqa
322: WHERE sqa.srp_quota_assign_id = p_srp_quota_assign_id
323: AND q.quota_id = sqa.quota_id;
324:
325: IF Nvl(l_payee_assign_flag,'N') <> 'Y' THEN

Line 520: FROM cn_srp_quota_assigns_all sqa, cn_srp_plan_assigns_all spa

516:
517: -- get properties from given srp_quota_assign_id
518: SELECT spa.salesrep_id, sqa.org_id, sqa.quota_id, spa.comp_plan_id
519: INTO l_salesrep_id, l_org_id, l_quota_id, l_comp_plan_id
520: FROM cn_srp_quota_assigns_all sqa, cn_srp_plan_assigns_all spa
521: WHERE srp_quota_assign_id = p_srp_quota_assign_id
522: AND sqa.srp_plan_assign_id = spa.srp_plan_assign_id;
523:
524: Valid_Srp_Payee_Assigns

Line 596: p_source_object_code => 'CN_SRP_QUOTA_ASSIGNS',

592: x_return_status => x_return_status,
593: x_msg_count => x_msg_count,
594: x_msg_data => x_msg_data,
595: p_source_object_id => p_srp_quota_assign_id,
596: p_source_object_code => 'CN_SRP_QUOTA_ASSIGNS',
597: p_notes => l_note_msg,
598: p_notes_detail => l_note_msg,
599: p_note_type => 'CN_SYSGEN', -- for system generated
600: x_jtf_note_id => l_note_id -- returned

Line 768: FROM cn_srp_quota_assigns_all sqa, cn_srp_plan_assigns_all spa

764:
765: -- get properties from given srp_quota_assign_id
766: SELECT spa.comp_plan_id
767: INTO l_comp_plan_id
768: FROM cn_srp_quota_assigns_all sqa, cn_srp_plan_assigns_all spa
769: WHERE sqa.srp_quota_assign_id = l_old_rec.srp_quota_assign_id
770: AND sqa.srp_plan_assign_id = spa.srp_plan_assign_id;
771:
772: Valid_Srp_Payee_Assigns

Line 1169: p_source_object_code => 'CN_SRP_QUOTA_ASSIGNS',

1165: x_return_status => x_return_status,
1166: x_msg_count => x_msg_count,
1167: x_msg_data => x_msg_data,
1168: p_source_object_id => l_srp_quota_assign_id,
1169: p_source_object_code => 'CN_SRP_QUOTA_ASSIGNS',
1170: p_notes => l_note_msg,
1171: p_notes_detail => l_note_msg,
1172: p_note_type => 'CN_SYSGEN', -- for system generated
1173: x_jtf_note_id => l_note_id -- returned