APPS.CSTPSCCR dependencies on CST_SC_ROLLUP_HISTORY

Line 34: /* Get Last_Updated_By from cst_sc_rollup_history instead of FND_GLOBAL structure */

30: BEGIN
31:
32: status := 0;
33:
34: /* Get Last_Updated_By from cst_sc_rollup_history instead of FND_GLOBAL structure */
35: l_stmt_num := 5;
36: SELECT LAST_UPDATED_BY ,
37: LAST_UPDATE_LOGIN
38: INTO l_last_updated_by,

Line 40: FROM cst_sc_rollup_history

36: SELECT LAST_UPDATED_BY ,
37: LAST_UPDATE_LOGIN
38: INTO l_last_updated_by,
39: l_login_id
40: FROM cst_sc_rollup_history
41: WHERE rollup_id = p_rollup_id
42: AND ROWNUM=1;
43:
44: l_stmt_num := 10;

Line 772: from cst_sc_rollup_history

768: sql_stmt_num := 5;
769:
770: select LAST_UPDATE_LOGIN
771: into l_login_id
772: from cst_sc_rollup_history
773: where rollup_id = l_rollup_id
774: and rownum=1;
775:
776:

Line 2906: from cst_sc_rollup_history

2902: sql_stmt_num := 5;
2903:
2904: select nvl(LAST_UPDATE_LOGIN ,-1 )
2905: into l_login_id
2906: from cst_sc_rollup_history
2907: where rollup_id = l_rollup_id
2908: and rownum =1;
2909:
2910: