APPS.CN_FORMULA_COMMON_PKG dependencies on JTF_RS_ROLES_B

Line 2473: l_mgr_role_flag jtf_rs_roles_b.manager_flag%TYPE;

2469: -- 'POP' event, ??? set process_all_flag = 'Y', THRESHOLD ???
2470: -- 'CALC' event, not handled here, only action 'DELETE' is handled.
2471: -- 'NCALC' event , not handled here, in ROLLUP phase
2472:
2473: l_mgr_role_flag jtf_rs_roles_b.manager_flag%TYPE;
2474: l_mem_role_flag jtf_rs_roles_b.member_flag%TYPE;
2475: l_org_id number;
2476:
2477: -- cursor to get the old manager_flag

Line 2474: l_mem_role_flag jtf_rs_roles_b.member_flag%TYPE;

2470: -- 'CALC' event, not handled here, only action 'DELETE' is handled.
2471: -- 'NCALC' event , not handled here, in ROLLUP phase
2472:
2473: l_mgr_role_flag jtf_rs_roles_b.manager_flag%TYPE;
2474: l_mem_role_flag jtf_rs_roles_b.member_flag%TYPE;
2475: l_org_id number;
2476:
2477: -- cursor to get the old manager_flag
2478: CURSOR role_flag_cur (p_role_id NUMBER)IS

Line 2480: FROM jtf_rs_roles_b

2476:
2477: -- cursor to get the old manager_flag
2478: CURSOR role_flag_cur (p_role_id NUMBER)IS
2479: SELECT member_flag, manager_flag
2480: FROM jtf_rs_roles_b
2481: WHERE role_id = p_role_id
2482: AND role_type_code = 'SALES_COMP';
2483:
2484: CURSOR l_log_rep_del_actions_csr IS