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

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

Line 1117: -- Case 3: Delete will be called from cn_srp_plan_assigns date range has

1113: -- flag if N then delete delete the srp_period_quotas and re create.
1114: -- called from cn_period_quotas
1115: -- Values Passed x_quota_id (M )
1116: --
1117: -- Case 3: Delete will be called from cn_srp_plan_assigns date range has
1118: -- changed if end date is less than the end date of the old plan date
1119: -- Delete will be called from cn_srp_plan_assigns if start_date
1120: -- <> old_start_dt called from cn_srp_plan_assigns_pkg
1121: -- Values Passed : x_srp_plan_assign_id, x_start_date, x_end_date

Line 1119: -- Delete will be called from cn_srp_plan_assigns if start_date

1115: -- Values Passed x_quota_id (M )
1116: --
1117: -- Case 3: Delete will be called from cn_srp_plan_assigns date range has
1118: -- changed if end date is less than the end date of the old plan date
1119: -- Delete will be called from cn_srp_plan_assigns if start_date
1120: -- <> old_start_dt called from cn_srp_plan_assigns_pkg
1121: -- Values Passed : x_srp_plan_assign_id, x_start_date, x_end_date
1122: --
1123: -- Case 4 Delete srp_plan_assigns Called cn_srp_quota_assigns and

Line 1120: -- <> old_start_dt called from cn_srp_plan_assigns_pkg

1116: --
1117: -- Case 3: Delete will be called from cn_srp_plan_assigns date range has
1118: -- changed if end date is less than the end date of the old plan date
1119: -- Delete will be called from cn_srp_plan_assigns if start_date
1120: -- <> old_start_dt called from cn_srp_plan_assigns_pkg
1121: -- Values Passed : x_srp_plan_assign_id, x_start_date, x_end_date
1122: --
1123: -- Case 4 Delete srp_plan_assigns Called cn_srp_quota_assigns and
1124: -- cn_srp_quota_assigns make a call here

Line 1229: FROM cn_srp_plan_assigns

1225:
1226: ELSE
1227: -- make sure we have the right org ID
1228: SELECT org_id INTO l_org_id
1229: FROM cn_srp_plan_assigns
1230: WHERE srp_plan_assign_id = x_srp_plan_assign_id;
1231:
1232: -- get end date period of x_end_date
1233: l_end_date_pd := Trunc(cn_end_date_period(x_end_date, l_org_id));