APPS.GMD_COA_DATA_NEW dependencies on OP_BILL_LAD

Line 1397: CURSOR get_bol_info (c_bol_id op_bill_lad.bol_no%TYPE) IS

1393: WHERE generic_id = c_generic_id
1394: and delete_mark = 0
1395: ;
1396:
1397: CURSOR get_bol_info (c_bol_id op_bill_lad.bol_no%TYPE) IS
1398: SELECT bol_no
1399: FROM
1400: op_bill_lad
1401: WHERE bol_id = c_bol_id

Line 1400: op_bill_lad

1396:
1397: CURSOR get_bol_info (c_bol_id op_bill_lad.bol_no%TYPE) IS
1398: SELECT bol_no
1399: FROM
1400: op_bill_lad
1401: WHERE bol_id = c_bol_id
1402: and delete_mark = 0
1403: ;
1404:

Line 1772: /* get bol (shipping no) from op_bill_lad */

1768: /* var to Populate_Details, so cannot change report_title there.) */
1769:
1770: tbl_hdr(loop_counter).report_title := v_report_title;
1771:
1772: /* get bol (shipping no) from op_bill_lad */
1773:
1774: IF tbl_hdr(loop_counter).bol_id is not NULL THEN
1775: FOR bol_cur_rec IN get_bol_info (tbl_hdr(loop_counter).bol_id) LOOP
1776: tbl_hdr(loop_counter).bol_no := bol_cur_rec.bol_no;

Line 1778: /* end getting bol (shipping) info from op_bill_lad */

1774: IF tbl_hdr(loop_counter).bol_id is not NULL THEN
1775: FOR bol_cur_rec IN get_bol_info (tbl_hdr(loop_counter).bol_id) LOOP
1776: tbl_hdr(loop_counter).bol_no := bol_cur_rec.bol_no;
1777: END LOOP;
1778: /* end getting bol (shipping) info from op_bill_lad */
1779: END IF;
1780: /* end checking if bol id has a value */
1781: /* get customer no and name from op_cust_mst tables */
1782: