APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_SRP_PLAN_ASSIGNS

Line 515: cn_srp_plan_assigns_all pa ,

511: l_login_id ,
512: qa.org_id
513: FROM cn_srp_quota_assigns_all qa ,
514: cn_period_quotas_all pq ,
515: cn_srp_plan_assigns_all pa ,
516: cn_period_statuses p
517: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id
518: AND pa.srp_plan_assign_id = x_srp_plan_assign_id
519: AND pa.srp_plan_assign_id = qa.srp_plan_assign_id --bugfix3633222

Line 630: cn_srp_plan_assigns_all pa ,

626: l_login_id ,
627: qa.org_id
628: FROM cn_srp_quota_assigns_all qa ,
629: cn_period_quotas_all pq ,
630: cn_srp_plan_assigns_all pa ,
631: cn_period_statuses p
632: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id
633: AND pa.srp_plan_assign_id = qa.srp_plan_assign_id
634: AND qa.quota_id = x_quota_id

Line 730: cn_srp_plan_assigns_all pa ,

726: l_login_id ,
727: qa.org_id
728: FROM cn_srp_quota_assigns_all qa ,
729: cn_quotas_all q ,
730: cn_srp_plan_assigns_all pa ,
731: cn_acc_period_statuses_v p
732: -- bug fix 4042235
733: ,
734: cn_period_statuses p2 ,

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

1074: -- flag if N then delete delete the srp_period_quotas and re create.
1075: -- called from cn_period_quotas
1076: -- Values Passed x_quota_id (M )
1077: --
1078: -- Case 3: Delete will be called from cn_srp_plan_assigns date range has
1079: -- changed if end date is less than the end date of the old plan date
1080: -- Delete will be called from cn_srp_plan_assigns if start_date
1081: -- <> old_start_dt called from cn_srp_plan_assigns_pkg
1082: -- Values Passed : x_srp_plan_assign_id, x_start_date, x_end_date

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

1076: -- Values Passed x_quota_id (M )
1077: --
1078: -- Case 3: Delete will be called from cn_srp_plan_assigns date range has
1079: -- changed if end date is less than the end date of the old plan date
1080: -- Delete will be called from cn_srp_plan_assigns if start_date
1081: -- <> old_start_dt called from cn_srp_plan_assigns_pkg
1082: -- Values Passed : x_srp_plan_assign_id, x_start_date, x_end_date
1083: --
1084: -- Case 4 Delete srp_plan_assigns Called cn_srp_quota_assigns and

Line 1081: -- <> old_start_dt called from cn_srp_plan_assigns_pkg

1077: --
1078: -- Case 3: Delete will be called from cn_srp_plan_assigns date range has
1079: -- changed if end date is less than the end date of the old plan date
1080: -- Delete will be called from cn_srp_plan_assigns if start_date
1081: -- <> old_start_dt called from cn_srp_plan_assigns_pkg
1082: -- Values Passed : x_srp_plan_assign_id, x_start_date, x_end_date
1083: --
1084: -- Case 4 Delete srp_plan_assigns Called cn_srp_quota_assigns and
1085: -- cn_srp_quota_assigns make a call here

Line 1213: FROM cn_srp_plan_assigns

1209: ELSE
1210: -- make sure we have the right org ID
1211: SELECT org_id
1212: INTO l_org_id
1213: FROM cn_srp_plan_assigns
1214: WHERE srp_plan_assign_id = x_srp_plan_assign_id;
1215: -- get end date period of x_end_date
1216: l_end_date_pd := TRUNC(cn_end_date_period(x_end_date, l_org_id));
1217: -- plan assignment range changed