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 1066: FROM JAI_OM_OE_BOND_REG_DTLS

1062: SELECT register_code
1063: FROM JAI_OM_OE_BOND_REG_HDRS
1064: WHERE organization_id = p_org_id AND location_id = p_loc_id AND
1065: register_id IN (SELECT register_id
1066: FROM JAI_OM_OE_BOND_REG_DTLS
1067: WHERE order_type_id = pr_new.batch_source_id AND order_flag= 'N'); /* Modified by Ramananda for removal of SQL LITERALs */
1068:
1069: CURSOR fin_year_cur(p_org_id IN NUMBER) IS
1070: SELECT MAX(A.fin_year)

Line 2915: FROM JAI_OM_OE_BOND_REG_DTLS

2911: SELECT register_code
2912: FROM JAI_OM_OE_BOND_REG_HDRS
2913: WHERE organization_id = p_org_id AND location_id = p_loc_id AND
2914: register_id IN (SELECT register_id
2915: FROM JAI_OM_OE_BOND_REG_DTLS
2916: WHERE order_type_id = p_batch_source_id AND order_flag = 'N');
2917:
2918: /* Bug5207772. Added by Lakshmi Gopalsami
2919: Fixed performance issue - SQL id - 17698796

Line 2928: JAI_OM_OE_BOND_REG_DTLS b,

2924: p_location_id NUMBER,
2925: p_order_type VARCHAR2) IS
2926: SELECT A.register_code
2927: FROM JAI_OM_OE_BOND_REG_HDRS A,
2928: JAI_OM_OE_BOND_REG_DTLS b,
2929: oe_transaction_types_tl ott
2930: WHERE A.organization_id = p_organization_id
2931: AND A.location_id = p_location_id
2932: AND A.register_id = b.register_id