DBA Data[Home] [Help]

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 449: FROM DUAL;

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

Line 984: FROM DUAL;

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

Line 1148: FROM dual;

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

Line 1299: FROM dual;

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