APPS.CN_SRP_PLAN_ASSIGNS_PVT dependencies on CN_SRP_PAY_GROUPS

Line 29: l_srp_pay_grp_sd cn_srp_pay_groups.start_date%TYPE;

25: l_api_name CONSTANT VARCHAR2(30) := 'valid_srp_plan_assign';
26: l_dummy NUMBER;
27: l_srp_roles_row cn_srp_roles%ROWTYPE;
28: l_role_plans_row cn_role_plans%ROWTYPE;
29: l_srp_pay_grp_sd cn_srp_pay_groups.start_date%TYPE;
30: l_srp_pay_grp_ed cn_srp_pay_groups.end_date%TYPE;
31: l_spg_max_sd cn_srp_pay_groups.start_date%TYPE;
32: l_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE;
33:

Line 30: l_srp_pay_grp_ed cn_srp_pay_groups.end_date%TYPE;

26: l_dummy NUMBER;
27: l_srp_roles_row cn_srp_roles%ROWTYPE;
28: l_role_plans_row cn_role_plans%ROWTYPE;
29: l_srp_pay_grp_sd cn_srp_pay_groups.start_date%TYPE;
30: l_srp_pay_grp_ed cn_srp_pay_groups.end_date%TYPE;
31: l_spg_max_sd cn_srp_pay_groups.start_date%TYPE;
32: l_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE;
33:
34: l_temp_count NUMBER;

Line 31: l_spg_max_sd cn_srp_pay_groups.start_date%TYPE;

27: l_srp_roles_row cn_srp_roles%ROWTYPE;
28: l_role_plans_row cn_role_plans%ROWTYPE;
29: l_srp_pay_grp_sd cn_srp_pay_groups.start_date%TYPE;
30: l_srp_pay_grp_ed cn_srp_pay_groups.end_date%TYPE;
31: l_spg_max_sd cn_srp_pay_groups.start_date%TYPE;
32: l_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE;
33:
34: l_temp_count NUMBER;
35: BEGIN

Line 32: l_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE;

28: l_role_plans_row cn_role_plans%ROWTYPE;
29: l_srp_pay_grp_sd cn_srp_pay_groups.start_date%TYPE;
30: l_srp_pay_grp_ed cn_srp_pay_groups.end_date%TYPE;
31: l_spg_max_sd cn_srp_pay_groups.start_date%TYPE;
32: l_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE;
33:
34: l_temp_count NUMBER;
35: BEGIN
36: -- Initialize API return status to success

Line 102: FROM cn_srp_pay_groups

98:
99: -- check whether paygroup assignment exists or not
100: SELECT count(1)
101: INTO l_temp_count
102: FROM cn_srp_pay_groups
103: WHERE salesrep_id = x_srp_plan_assigns_row.salesrep_id
104: AND org_id = x_srp_plan_assigns_row.org_id; -- MOAC
105:
106:

Line 114: FROM cn_srp_pay_groups

110:
111: -- Get srp_pay_groups : min(start date)
112: SELECT MIN(start_date), MAX(start_date)
113: INTO l_srp_pay_grp_sd, l_spg_max_sd
114: FROM cn_srp_pay_groups
115: WHERE salesrep_id = x_srp_plan_assigns_row.salesrep_id
116: AND org_id = x_srp_plan_assigns_row.org_id; -- MOAC
117:
118: BEGIN

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;

Line 291: from cn_srp_pay_groups

287:
288: CURSOR pg_cur(srp_id number, l_org_id number)
289: IS
290: select start_date, end_date
291: from cn_srp_pay_groups
292: where salesrep_id = srp_id
293: and org_id = l_org_id; -- MOAC
294:
295: pg_cur_rec pg_cur%ROWTYPE;

Line 511: from cn_srp_pay_groups

507: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
508:
509: CURSOR pg_cur(srp_id number, l_org_id number) IS
510: select start_date, end_date
511: from cn_srp_pay_groups
512: where salesrep_id = srp_id
513: and org_id = l_org_id; --MOAC
514:
515: pg_cur_rec pg_cur%ROWTYPE;