APPS.POA_EDW_CSTM_MSR_F_C dependencies on POA_EDW_CSTM_MSR_INC

Line 28: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_EDW_CSTM_MSR_INC';

24:
25: BEGIN
26:
27: IF (FND_INSTALLATION.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
28: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_EDW_CSTM_MSR_INC';
29: EXECUTE IMMEDIATE l_stmt;
30: END IF;
31:
32: END;

Line 193: select poa_edw_cstm_msr_inc_s.nextval into l_seq_id from dual;

189:
190: BEGIN
191:
192: p_count := 0;
193: select poa_edw_cstm_msr_inc_s.nextval into l_seq_id from dual;
194:
195: INSERT INTO poa_edw_cstm_msr_inc(primary_key, seq_id)
196: SELECT pms.evaluation_score_id, l_seq_id
197: FROM poa_cm_eval_scores pms,

Line 195: INSERT INTO poa_edw_cstm_msr_inc(primary_key, seq_id)

191:
192: p_count := 0;
193: select poa_edw_cstm_msr_inc_s.nextval into l_seq_id from dual;
194:
195: INSERT INTO poa_edw_cstm_msr_inc(primary_key, seq_id)
196: SELECT pms.evaluation_score_id, l_seq_id
197: FROM poa_cm_eval_scores pms,
198: poa_cm_evaluation pme
199: WHERE pms.evaluation_id = pme.evaluation_id