APPS.CN_SRP_PLAN_ASSIGNS_PVT dependencies on CN_PAY_GROUPS

Line 108: -- if it's NULL, get the end_date from cn_pay_groups

104: AND org_id = x_srp_plan_assigns_row.org_id; -- MOAC
105:
106:
107: -- Get srp_pay_groups : max(end date) from max(start_date) record
108: -- if it's NULL, get the end_date from cn_pay_groups
109: IF l_temp_count > 0 THEN
110:
111: -- Get srp_pay_groups : min(start date)
112: SELECT MIN(start_date), MAX(start_date)

Line 122: FROM cn_srp_pay_groups spg, cn_pay_groups pg

118: BEGIN
119: SELECT Decode(spg.end_date, NULL, pg.end_date,spg.end_date),
120: spg.pay_group_id
121: INTO l_srp_pay_grp_ed,l_pay_group_id
122: FROM cn_srp_pay_groups spg, cn_pay_groups pg
123: WHERE spg.pay_group_id = pg.pay_group_id
124: AND spg.salesrep_id = x_srp_plan_assigns_row.salesrep_id
125: AND spg.org_id = x_srp_plan_assigns_row.org_id -- MOAC
126: AND spg.start_date = l_spg_max_sd;