APPS.CN_SRP_PMT_PLANS_PUB dependencies on DUAL

Line 242: FROM dual;

238: p_srp_pmt_plans_rec.maximum_amount)
239: INTO
240: x_srp_pmt_plans_row.minimum_amount,
241: x_srp_pmt_plans_row.maximum_amount
242: FROM dual;
243:
244: -- End of API body.
245: EXCEPTION
246: WHEN FND_API.G_EXC_ERROR THEN

Line 358: FROM dual;

354: l_spp_rec.salesrep_type,
355: l_spp_rec.emp_num,
356: l_spp_rec.start_date,
357: l_spp_rec.end_date
358: FROM dual;
359: --
360: -- Valid payment plan assignment
361: --
362: valid_pp_assign

Line 736: FROM dual;

732: l_old_spp_rec.salesrep_type,
733: l_old_spp_rec.emp_num,
734: l_old_spp_rec.start_date,
735: l_old_spp_rec.end_date
736: FROM dual;
737: -- Get IDs
738: chk_existence_get_id
739: ( x_return_status => x_return_status,
740: x_msg_count => x_msg_count,

Line 789: FROM dual;

785: l_spp_rec.salesrep_type,
786: l_spp_rec.emp_num,
787: l_spp_rec.start_date,
788: l_spp_rec.end_date
789: FROM dual;
790:
791: --
792: -- Valid payment plan assignment
793: --

Line 1142: FROM dual;

1138: l_spp_rec.salesrep_type,
1139: l_spp_rec.emp_num,
1140: l_spp_rec.start_date,
1141: l_spp_rec.end_date
1142: FROM dual;
1143: -- Get IDs
1144: chk_existence_get_id
1145: ( x_return_status => x_return_status,
1146: x_msg_count => x_msg_count,