DBA Data[Home] [Help]

APPS.OPI_DBI_BOUNDS_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 1572: -- Inserting rows into the temp table from org_organization_definitions and

1568: l_debug_msg := 'Deleted '||to_char(sql%rowcount)||' rows from OPI_DBI_ORG_LE_TEMP' ;
1569: opi_dbi_bounds_pkg.write(g_pkg_name, l_proc_name, l_stmt_no, l_debug_msg);
1570: END IF;
1571:
1572: -- Inserting rows into the temp table from org_organization_definitions and
1573: -- gmf_fiscal_policies
1574:
1575: l_stmt_no := 20;
1576: INSERT INTO OPI_DBI_ORG_LE_TEMP

Line 1587: FROM ORG_ORGANIZATION_DEFINITIONS ood,

1583: SELECT ood.organization_id ,
1584: gfp.ledger_id ,
1585: gfp.legal_entity_id ,
1586: gfp.cost_type_id
1587: FROM ORG_ORGANIZATION_DEFINITIONS ood,
1588: GMF_FISCAL_POLICIES gfp,
1589: MTL_PARAMETERS mp
1590: WHERE mp.process_enabled_flag = 'Y' --for OPM orgs only
1591: AND mp.organization_id = ood.organization_id