DBA Data[Home] [Help]

APPS.JAI_ENCUM_PRC dependencies on PO_ENCUMBRANCE_GT

Line 44: FROM po_encumbrance_gt

40: /*Cursor used to fetch the line_location_id using distribution_id*/
41: CURSOR cur_line_location_id(cp_distribution_id NUMBER)
42: IS
43: SELECT line_location_id
44: FROM po_encumbrance_gt
45: WHERE distribution_id = cp_distribution_id;
46:
47: /*Cursor to fetch the po_line_id using line_location_id*/
48: CURSOR cur_po_line_id(cp_line_location_id NUMBER)

Line 67: FROM po_encumbrance_gt

63:
64: CURSOR cur_req_line_id(cp_distribution_id NUMBER)
65: IS
66: SELECT distinct(line_id)
67: FROM po_encumbrance_gt
68: WHERE distribution_id = cp_distribution_id;
69:
70: /*Cursor to fetch currency, conversion rate and header id of the requistion*/
71: CURSOR cur_req_line_dtls(cp_req_line_id NUMBER)