APPS.GCS_AD_TRIALBALANCE_PKG dependencies on GCS_CONS_ENG_RUN_DTLS

Line 226: FROM gcs_cons_eng_run_dtls gcerd

222: SELECT 'Y'
223: INTO l_processed_entry_flag
224: FROM DUAL
225: WHERE EXISTS (SELECT run_detail_id
226: FROM gcs_cons_eng_run_dtls gcerd
227: WHERE gcerd.entry_id = l_entry_id);
228: EXCEPTION
229: WHEN NO_DATA_FOUND
230: THEN

Line 1178: FROM gcs_ad_transactions xns, gcs_cons_eng_run_dtls gcerd

1174: )
1175: IS
1176: cursor undo_c is
1177: SELECT decode(NVL(gcerd.run_detail_id, 0), 0, 'N', 'Y'), xns.assoc_entry_id
1178: FROM gcs_ad_transactions xns, gcs_cons_eng_run_dtls gcerd
1179: WHERE xns.ad_transaction_id = p_xns_id
1180: and gcerd.entry_id (+) = xns.assoc_entry_id;
1181:
1182: l_processed_flag VARCHAR2 (1);