eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_SRP_PLAN_ASSIGNS_ALL

Line 531: ,cn_srp_plan_assigns_all pa

527: ,l_login_id
528: ,qa.org_id
529: FROM cn_srp_quota_assigns_all qa
530: ,cn_period_quotas_all pq
531: ,cn_srp_plan_assigns_all pa
532: ,cn_period_statuses p
533: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id
534: AND pa.srp_plan_assign_id = x_srp_plan_assign_id
535: AND pa.srp_plan_assign_id = qa.srp_plan_assign_id --bugfix3633222

Line 643: ,cn_srp_plan_assigns_all pa

639: ,l_login_id
640: ,qa.org_id
641: FROM cn_srp_quota_assigns_all qa
642: ,cn_period_quotas_all pq
643: ,cn_srp_plan_assigns_all pa
644: ,cn_period_statuses p
645: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id
646: AND pa.srp_plan_assign_id = qa.srp_plan_assign_id
647: AND qa.quota_id = x_quota_id

Line 734: ,cn_srp_plan_assigns_all pa

730: ,l_login_id
731: ,qa.org_id
732: FROM cn_srp_quota_assigns_all qa
733: ,cn_quotas_all q
734: ,cn_srp_plan_assigns_all pa
735: ,cn_acc_period_statuses_v p
736: -- bug fix 4042235
737: ,cn_period_statuses p2
738: ,cn_period_statuses p3