DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJ_PVT dependencies on OZF_SD_REQUEST_LINES_ALL

Line 1190: FROM ozf_sd_request_lines_all

1186: ,requested_discount_currency
1187: ,product_cost_currency
1188: ,end_customer_currency
1189: ,approved_discount_currency
1190: FROM ozf_sd_request_lines_all
1191: WHERE request_line_id = p_request_line_id;
1192:
1193: CURSOR c_reqest_lines_seq IS
1194: SELECT ozf_sd_request_lines_all_s.nextval

Line 1194: SELECT ozf_sd_request_lines_all_s.nextval

1190: FROM ozf_sd_request_lines_all
1191: WHERE request_line_id = p_request_line_id;
1192:
1193: CURSOR c_reqest_lines_seq IS
1194: SELECT ozf_sd_request_lines_all_s.nextval
1195: FROM dual;
1196:
1197: l_get_sdr_line c_get_sdr_line%ROWTYPE;
1198: l_listLineId c_listLineId%ROWTYPE;

Line 3612: SELECT ozf_sd_request_lines_all_s.nextval

3608: px_SDR_lines_tbl IN OUT NOCOPY OZF_SD_REQUEST_PUB.SDR_lines_tbl_type,
3609: p_SDR_hdr_pub_rec IN OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type)
3610: IS
3611: CURSOR c_reqest_lines_seq IS
3612: SELECT ozf_sd_request_lines_all_s.nextval
3613: FROM dual;
3614:
3615: CURSOR c_get_offer_hdr (p_list_header_id IN NUMBER) IS
3616: SELECT custom_setup_id