APPS.CN_FORMULA_COMMON_PKG dependencies on JTF_RS_ROLES_B

Line 2457: l_mgr_role_flag jtf_rs_roles_b.manager_flag%TYPE;

2453: -- 'POP' event, ??? set process_all_flag = 'Y', THRESHOLD ???
2454: -- 'CALC' event, not handled here, only action 'DELETE' is handled.
2455: -- 'NCALC' event , not handled here, in ROLLUP phase
2456:
2457: l_mgr_role_flag jtf_rs_roles_b.manager_flag%TYPE;
2458: l_mem_role_flag jtf_rs_roles_b.member_flag%TYPE;
2459: l_org_id number;
2460:
2461: -- cursor to get the old manager_flag

Line 2458: l_mem_role_flag jtf_rs_roles_b.member_flag%TYPE;

2454: -- 'CALC' event, not handled here, only action 'DELETE' is handled.
2455: -- 'NCALC' event , not handled here, in ROLLUP phase
2456:
2457: l_mgr_role_flag jtf_rs_roles_b.manager_flag%TYPE;
2458: l_mem_role_flag jtf_rs_roles_b.member_flag%TYPE;
2459: l_org_id number;
2460:
2461: -- cursor to get the old manager_flag
2462: CURSOR role_flag_cur (p_role_id NUMBER)IS

Line 2464: FROM jtf_rs_roles_b

2460:
2461: -- cursor to get the old manager_flag
2462: CURSOR role_flag_cur (p_role_id NUMBER)IS
2463: SELECT member_flag, manager_flag
2464: FROM jtf_rs_roles_b
2465: WHERE role_id = p_role_id
2466: AND role_type_code = 'SALES_COMP';
2467:
2468: CURSOR l_log_rep_del_actions_csr IS