APPS.CN_API dependencies on CN_SRP_PLAN_ASSIGNS

Line 3135: cn_srp_plan_assigns assign,

3131: IS
3132: SELECT DISTINCT t.role_name role_name,
3133: assign.start_date
3134: FROM cn_srp_periods srp ,
3135: cn_srp_plan_assigns assign,
3136: JTF_RS_ROLES_TL T ,
3137: JTF_RS_ROLES_B B
3138: WHERE assign.srp_plan_assign_id(+)= srp.srp_plan_assign_id
3139: AND srp.period_id = l_period_id

Line 3151: cn_srp_plan_assigns assign,

3147: ORDER BY assign.start_date;
3148:
3149: /*SELECT distinct r.name role_name,assign.start_date
3150: FROM cn_srp_periods srp,
3151: cn_srp_plan_assigns assign,
3152: cn_roles r
3153: WHERE assign.srp_plan_assign_id(+)= srp.srp_plan_assign_id
3154: AND srp.period_id = l_period_id
3155: AND assign.role_id = r.role_id(+)

Line 3222: FROM CN_SRP_PLAN_ASSIGNS assign ,

3218: CURSOR get_role_cursor
3219: IS
3220: SELECT /*+ leading(cnw_srp,assign) use_nl(assign,rl) */ DISTINCT
3221: cnw_srp.SALESREP_ID, cnw_srp.PERIOD_ID, RL.ROLE_NAME, ASSIGN.START_DATE
3222: FROM CN_SRP_PLAN_ASSIGNS assign ,
3223: JTF_RS_ROLES_VL rl ,
3224: (SELECT TO_NUMBER(SUBSTR(column_value, 1, INSTR(column_value, '-', 1, 1) - 1 ) ) SALESREP_ID,
3225: TO_NUMBER(SUBSTR(column_value , INSTR(column_value, '-', 1, 1) + 1,
3226: (INSTR(column_value, '-', 1, 2) - INSTR(column_value, '-', 1, 1))-1) ) PLANASSIGNID,