APPS.GHG_TRANSACTIONS_PKG dependencies on GHG_TRANSACTION_BATCHES

Line 884: from GHG_transaction_batches b,

880: mo_global.set_policy_context_server(p_access_mode => 'S',p_org_id =>lp_org_id);
881:
882: select count(*)
883: into v_count
884: from GHG_transaction_batches b,
885: GHG_TRANSACTIONS e
886: where b.transaction_batch_id = e.transaction_batch_id
887: and b.transaction_batch_number = 'INV Issue:'||P_MATERIAL_TRX_SET_ID
888: and e.description = p_TRANS_REF;

Line 896: from GHG_transaction_batches b,

892:
893: delete from ghg_transaction_details d
894: where exists (
895: select 1
896: from GHG_transaction_batches b,
897: GHG_TRANSACTIONS e
898: where b.transaction_batch_id = e.transaction_batch_id
899: and b.transaction_batch_number = 'INV Issue:'||P_MATERIAL_TRX_SET_ID
900: and e.description = p_TRANS_REF

Line 908: from GHG_transaction_batches b

904: delete from ghg_transactions e
905: where e.description = p_TRANS_REF
906: and exists (
907: select 1
908: from GHG_transaction_batches b
909: where b.transaction_batch_id = e.transaction_batch_id
910: and b.transaction_batch_number = 'INV Issue:'||P_MATERIAL_TRX_SET_ID
911: );
912: