APPS.CN_ADJUSTMENTS_PKG dependencies on DUAL

Line 196: FROM dual;

192: LOOP
193: --
194: SELECT cn_comm_lines_api_s.NEXTVAL
195: INTO l_comm_lines_api_id
196: FROM dual;
197: --
198: l_api_rec.salesrep_id := api_curs_rec.direct_salesrep_id;
199: l_api_rec.processed_date := api_curs_rec.processed_date;
200: l_api_rec.processed_period_id := api_curs_rec.processed_period_id;

Line 448: FROM DUAL;

444: END IF;
445: --
446: SELECT cn_comm_lines_api_s.NEXTVAL
447: INTO l_comm_lines_api_id
448: FROM DUAL;
449: --
450:
451:
452: SELECT DECODE(x_adj_rec.direct_salesrep_id,fnd_api.g_miss_num,

Line 983: FROM DUAL;

979: l_api_rec.split_status,
980: l_api_rec.org_id,
981: l_api_rec.terr_id,
982: l_api_rec.preserve_credit_override_flag
983: FROM DUAL;
984:
985: --Added for Crediting
986: IF(x_adj_data(i).terr_id IS NOT NULL)
987: THEN

Line 1146: FROM dual;

1142: WHERE salesrep_id = x_salesrep_id;
1143: --
1144: SELECT cn_comm_lines_api_s.NEXTVAL
1145: INTO l_ins_comm_lines_api_id
1146: FROM dual;
1147: --
1148: l_newtx_rec.direct_salesrep_id := x_salesrep_id;
1149: l_newtx_rec.transaction_amount := l_transaction_amount;
1150: l_newtx_rec.load_status := 'UNLOADED';

Line 1297: FROM dual;

1293: WHERE salesrep_id = x_to_salesrep_id;
1294: --
1295: SELECT cn_comm_lines_api_s.NEXTVAL
1296: INTO l_ins_comm_lines_api_id
1297: FROM dual;
1298: --
1299: l_newtx_rec.direct_salesrep_id := x_to_salesrep_id;
1300: l_newtx_rec.transaction_amount := l_transaction_amount;
1301: l_newtx_rec.load_status := 'UNLOADED';