APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_OM_OE_BOND_REG_DTLS

Line 91: FROM JAI_OM_OE_BOND_REG_DTLS

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

Line 1054: FROM JAI_OM_OE_BOND_REG_DTLS

1050: SELECT register_code
1051: FROM JAI_OM_OE_BOND_REG_HDRS
1052: WHERE organization_id = p_org_id AND location_id = p_loc_id AND
1053: register_id IN (SELECT register_id
1054: FROM JAI_OM_OE_BOND_REG_DTLS
1055: WHERE order_type_id = pr_new.batch_source_id AND order_flag= 'N'); /* Modified by Ramananda for removal of SQL LITERALs */
1056:
1057: CURSOR fin_year_cur(p_org_id IN NUMBER) IS
1058: SELECT MAX(A.fin_year)

Line 2485: FROM JAI_OM_OE_BOND_REG_DTLS

2481: SELECT register_code
2482: FROM JAI_OM_OE_BOND_REG_HDRS
2483: WHERE organization_id = p_org_id AND location_id = p_loc_id AND
2484: register_id IN (SELECT register_id
2485: FROM JAI_OM_OE_BOND_REG_DTLS
2486: WHERE order_type_id = p_batch_source_id AND order_flag = 'N');
2487:
2488: /* Bug5207772. Added by Lakshmi Gopalsami
2489: Fixed performance issue - SQL id - 17698796

Line 2498: JAI_OM_OE_BOND_REG_DTLS b,

2494: p_location_id NUMBER,
2495: p_order_type VARCHAR2) IS
2496: SELECT A.register_code
2497: FROM JAI_OM_OE_BOND_REG_HDRS A,
2498: JAI_OM_OE_BOND_REG_DTLS b,
2499: oe_transaction_types_tl ott
2500: WHERE A.organization_id = p_organization_id
2501: AND A.location_id = p_location_id
2502: AND A.register_id = b.register_id