DBA Data[Home] [Help]

APPS.JAI_AR_TRX_HEADERS_PKG dependencies on JAI_OM_OE_BOND_REG_DTLS

Line 90: FROM JAI_OM_OE_BOND_REG_DTLS

86: FROM JAI_OM_OE_BOND_REG_HDRS
87: WHERE organization_id = p_org_id
88: AND location_id = p_loc_id
89: AND register_id in (SELECT register_id
90: FROM JAI_OM_OE_BOND_REG_DTLS
91: WHERE order_type_id = pr_new.batch_source_id
92: AND order_flag = 'N');
93:
94: CURSOR organization_cur IS

Line 1885: FROM JAI_OM_OE_BOND_REG_DTLS

1881: FROM JAI_OM_OE_BOND_REG_HDRS
1882: WHERE organization_id = p_org_id
1883: AND location_id = p_loc_id
1884: AND register_id IN (SELECT register_id
1885: FROM JAI_OM_OE_BOND_REG_DTLS
1886: WHERE order_type_id = pr_new.batch_source_id
1887: AND order_flag = 'N');
1888:
1889: CURSOR fin_year_cur(p_org_id IN NUMBER) IS