APPS.POR_HISTORY_FEED_PKG dependencies on GL_SETS_OF_BOOKS

Line 1078: TYPE tab_base_curr IS TABLE OF gl_sets_of_books.currency_code%TYPE;

1074: TYPE tab_vendor_site_code IS TABLE OF po_vendor_sites.vendor_site_code%TYPE;
1075: TYPE tab_vendor_id IS TABLE OF po_vendors.vendor_id%TYPE;
1076: TYPE tab_vendor_site_id IS TABLE OF po_vendor_sites.vendor_site_id%TYPE;
1077: TYPE tab_order_date IS TABLE OF po_headers.last_update_date%TYPE;
1078: TYPE tab_base_curr IS TABLE OF gl_sets_of_books.currency_code%TYPE;
1079: TYPE tab_local_curr IS TABLE OF po_headers.currency_code%TYPE;
1080: TYPE tab_uom IS TABLE OF po_lines.unit_meas_lookup_code%TYPE;
1081: TYPE tab_item_num IS TABLE OF mtl_system_items_kfv.concatenated_segments%TYPE;
1082: TYPE tab_item_desc IS TABLE OF po_lines.item_description%TYPE;

Line 1086: TYPE tab_acct_id IS TABLE OF gl_sets_of_books.chart_of_accounts_id%TYPE;

1082: TYPE tab_item_desc IS TABLE OF po_lines.item_description%TYPE;
1083: TYPE tab_qty IS TABLE OF po_distributions.quantity_ordered%TYPE;
1084: TYPE tab_unit_price IS TABLE OF po_lines.unit_price%TYPE;
1085: TYPE tab_amount IS TABLE OF NUMBER;
1086: TYPE tab_acct_id IS TABLE OF gl_sets_of_books.chart_of_accounts_id%TYPE;
1087: TYPE tab_acct_code IS TABLE OF gl_code_combinations_kfv.concatenated_segments%TYPE;
1088: TYPE tab_appr_status IS TABLE OF po_headers.authorization_status%TYPE;
1089: TYPE tab_appr_date IS TABLE OF po_headers.approved_date%TYPE;
1090: TYPE tab_control_status IS TABLE OF po_headers.closed_code%TYPE;

Line 1182: GL_SETS_OF_BOOKS GSB,

1178: PO_VENDOR_SITES PVS,
1179: AP_CARDS AC,
1180: AP_CARD_PROGRAMS ACP,
1181: MTL_SYSTEM_ITEMS_KFV MSI,
1182: GL_SETS_OF_BOOKS GSB,
1183: FINANCIALS_SYSTEM_PARAMETERS FSP,
1184: iby_creditcard ibycc
1185:
1186: WHERE

Line 1257: GL_SETS_OF_BOOKS GSB,

1253: PO_VENDORS PV,
1254: PO_VENDOR_SITES PVS,
1255: AP_CARDS AC,
1256: AP_CARD_PROGRAMS ACP,
1257: GL_SETS_OF_BOOKS GSB,
1258: FINANCIALS_SYSTEM_PARAMETERS FSP,
1259: iby_creditcard ibycc
1260:
1261: WHERE

Line 1331: GL_SETS_OF_BOOKS GSB,

1327: PO_VENDORS PV,
1328: PO_VENDOR_SITES PVS,
1329: AP_CARDS AC,
1330: AP_CARD_PROGRAMS ACP,
1331: GL_SETS_OF_BOOKS GSB,
1332: FINANCIALS_SYSTEM_PARAMETERS FSP,
1333: iby_creditcard ibycc
1334:
1335: WHERE

Line 1408: GL_SETS_OF_BOOKS GSB,

1404: PO_VENDOR_SITES PVS,
1405: AP_CARDS AC,
1406: AP_CARD_PROGRAMS ACP,
1407: MTL_SYSTEM_ITEMS_KFV MSI,
1408: GL_SETS_OF_BOOKS GSB,
1409: FINANCIALS_SYSTEM_PARAMETERS FSP,
1410: iby_creditcard ibycc
1411:
1412: WHERE

Line 1478: GL_SETS_OF_BOOKS GSB,

1474: PO_VENDORS PV,
1475: PO_VENDOR_SITES PVS,
1476: AP_CARDS AC,
1477: AP_CARD_PROGRAMS ACP,
1478: GL_SETS_OF_BOOKS GSB,
1479: FINANCIALS_SYSTEM_PARAMETERS FSP,
1480: iby_creditcard ibycc
1481:
1482: WHERE

Line 1536: GL_SETS_OF_BOOKS GSB,

1532: PO_VENDORS PV,
1533: PO_VENDOR_SITES PVS,
1534: AP_CARDS AC,
1535: AP_CARD_PROGRAMS ACP,
1536: GL_SETS_OF_BOOKS GSB,
1537: FINANCIALS_SYSTEM_PARAMETERS FSP,
1538: iby_creditcard ibycc
1539:
1540: WHERE

Line 1881: gl_sets_of_books gsb

1877:
1878: SELECT fsp.inventory_organization_id, gsb.chart_of_accounts_id, gsb.currency_code
1879: INTO g_inv_org_id, l_org_chart_of_accounts_id, l_func_curr_code
1880: FROM financials_system_parameters fsp,
1881: gl_sets_of_books gsb
1882: WHERE fsp.set_of_books_id = gsb.set_of_books_id
1883: AND fsp.org_id = g_org_id;
1884:
1885: l_progress := '300';